Several Countif criteria
 

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

Several Countif criteria
 

Try this:
Using your data in Cells A1:C10

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

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

XL2002, WinXP


"Martin" wrote:

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

Several Countif criteria
 

Many many thanks Ron,

It works like a dream.
--
Regards,

Martin


"Ron Coderre" wrote:

Try this:
Using your data in Cells A1:C10

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

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

XL2002, WinXP


"Martin" wrote:

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