View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dwake dwake is offline
external usenet poster
 
Posts: 41
Default SUMPRODUCT/COUNTIF???

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.