=SUMPRODUCT(--(A2:A100="Pilot"),--(B2:B100="Machine"),--(C2:C100="FY2009-Q4"))


Change ranges to fit your data

If you have multiple criteria to check then I would use cell references
instead of the hard coded criteria like


=SUMPRODUCT(--(A2:A100=D2),--(B2:B100=E2),--(C2:C100=F2))


as an example, the type the criteria in those cells. That way you don't have
to change the original formula only the criteria cells contents

--


Regards,


Peo Sjoblom


"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.