Thread: Count with two criteria
View Single Post
  #1  
Old March 18th, 2010, 04:39 PM posted to microsoft.public.excel.worksheet.functions
LisaK
external usenet poster
  
Posts: 143
Default Count with two criteria
I am working in Excel 2003, I am trying to count with two criteria and
multiple sheets.
I am using this formula: =SUMPRODUCT(('Sum 1Q10'!A2:A4="BKD")*('Sum
1Q10'!F2:F4="Open")) my result is 0. It should be 1.

Is there another way to do this? I really need help.