COUNTIF Multiple conditions
 

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

COUNTIF Multiple conditions
 

You could try it this way:

=SUMPRODUCT((A1:A100="May")*(B1:B1000))

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

Hope this helps.

Pete

On May 12, 8:55*am, stretch wrote:
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

COUNTIF Multiple conditions
 

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:B1000))

--
Adilson Soledade


"Pete_UK" wrote:

You could try it this way:

=SUMPRODUCT((A1:A100="May")*(B1:B1000))

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

Hope this helps.

Pete

On May 12, 8:55 am, stretch wrote:
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

COUNTIF Multiple conditions
 

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

"Adilson Soledade" wrote:

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:B1000))

--
Adilson Soledade


"Pete_UK" wrote:

You could try it this way:

=SUMPRODUCT((A1:A100="May")*(B1:B1000))

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

Hope this helps.

Pete

On May 12, 8:55 am, stretch wrote:
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