# Several Countif criteria

1. ## 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

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

2. ## RE: Several Countif criteria

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

"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
>
> 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

3. ## RE: 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:C10>20)*(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
> >
> > 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

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1