Several Countif criteria

M

Martin

Hi there,

I would like to do count values greater than 20 and less than 36 in Column
C, if looking for "B" in column A and "NO" in column B. Please extract of the
spreadsheet below.

Column A Column B Column C
A YES 15
B NO 20
B NO 35
B YES 36
B NO 37
B NO 25
B YES 30
B NO 10
K YES 10
K NO 10

I have tried with sum and sumproduct but am not able to get it right.

Any help much appreciated.
 
R

Ron Coderre

Try this:
Using your data in Cells A1:C10

D1: =SUMPRODUCT((A1:A10="B")*(B1:B10="NO")*(C1:C10>20)*(C1:C10<36))

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 
Top