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.
--
Regards,

Martin