View Single Post
  #1  
Old April 20th, 2010, 09:47 PM posted to microsoft.public.excel.misc
adriver
external usenet poster
 
Posts: 3
Default Adding digits in a column based on data in a separate column

I am making a log for incoming documents, and need to add the number of days
each type of document takes to be processed. Example:

Task Type Days to Complete
Type AA 10
Type AA 12
Type BB 6
Type CC 10
Type AA 8

Is there a way to count how many total days all "Type AA" documents took?
I've been trying COUNTIF variations and I can't get anything working.

THanks!