Brilliant! I've never seen SUMPRODUCT before, but I dare say my life just
got a lot easier. Thanks!

"Mike" wrote:

Assuming your AA = in Column =A, and Num of Days is in Column B.
=SUMPRODUCT(--(A1:A5="AA")*(B1:B5))

"adriver" wrote:

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!