Thread: SUM+IF Array formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PFAA PFAA is offline
external usenet poster
  
Posts: 9
Default SUM+IF Array formula
I'm using a {=SUM(IF((A2:A11="1188")*(B2:B11="Feb"),C2:C11))}

I need to count the # in Column C when the criteria is met in A and B. This
is an array formula.

And I keep getting 0....

What am I doing wrong?

Thanks,



Reply With QuoteReply With Quote