Check out Chip Pearson's website on Array Formulas....
http://www.cpearson.com/excel/array.htm

He addresses multiple criteria Count Ifs and Sum Ifs.

I believe this is exactly what you are looking for.

HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"DJS" wrote:

Hello~
I need to count all rows of Column B if they are not blank and only if the
contents of the same row in column A are =2005.
Is this possible without the use of a macro, and if so could you provide me
an example?