=SUMPRODUCT(--(A2:A5="Pilot"),--(B2:B5="Machine"),--(C2:C5="FY2009-Q4"))
--
David Biddulph

"dwake" wrote in message
...
So here is my situation:

A B C
Pilot Machine FY2009-Q4
Proto CEM FY2010-Q1
Pilot Commercial FY2010-Q2
Proto Machine FY2010-Q3

I'm having problem counting with multiple criteria. I want to add up all
the rows that meet certain criteria. So if the data meets the criteria of
pilot, machine, and FY2009-Q4, I would like it to count all those rows
that
meet that criteria to report on how many are happening in fourth quarter
of
2009.