COUNTIF Multiple conditions

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

stretch - 12 May 2008 08:55 GMT

I have a worksheet were I want to count the number of times a number larger
than 0 appears in the second column 'B', but only if the month is 'May' in
the first column 'A'. I seem to have problems using multiple COUNTIF
conditions, the solution is probably easy but its driving me mad!

A B
1 May 0
2 Feb 0
3 May 15
4 March 40
5 May 50

Reply to this Message

Pete_UK - 12 May 2008 09:13 GMT

You could try it this way:

=SUMPRODUCT((A1:A100="May")*(B1:B100>0))

This assumes that your months are entered as text values and not as
dates formatted to show only the month.

Hope this helps.

Pete

> I have a worksheet were I want to count the number of times a number larger
> than 0 appears in the second column 'B', but only if the month is 'May' in
[quoted text clipped - 7 lines]
> 4 March 40
> 5 May 50

Reply to this Message

Adilson Soledade - 12 May 2008 12:05 GMT

If the data in column A are data formated to show month only, you could use
this:
=SUMPRODUCT(N(MONTH(A1:A100)=5),N(B1:B100>0))

Signature

Adilson Soledade

> You could try it this way:
>
[quoted text clipped - 18 lines]
> > 4 March 40
> > 5 May 50

Reply to this Message

stretch - 12 May 2008 15:43 GMT

Data was formatted to show month only, many thanks, problem solved.

> If the data in column A are data formated to show month only, you could use
> this:
[quoted text clipped - 22 lines]
> > > 4 March 40
> > > 5 May 50

Reply to this Message

Rate this thread: