PDA

View Full Version : Solved: COUNTIF with multiple criteria



lawsonbooth
01-29-2008, 11:50 AM
I have search the forum and now my mind (which is simply too old to comprehend) is so overwhelmed. Can something tell me how to do the following with a formula?

Column A has year in it (e.g. 2007, 2008)
Column B has Type of question (e.g. Research, Error, Other)

I want to count how many times the ?type of question? = ?Other? and ?year? = ?2007?

Lawson :banghead:

Bob Phillips
01-29-2008, 12:49 PM
=SUMPRODUCT(--(A2:A200=2007),--(B2:B200="Other"))

Note that SUMPRODUCT doesn't work with complete columns, you have to specify a range.

lawsonbooth
01-30-2008, 06:24 AM
Thanks xld!!!

I had actually tried the formula you gave, however I was not aware of the rule that sumproduct must have a specific range. I was trying to do the whole column.

VBA Express Forum rocks!!! :rockband: