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

Pete_UK
Mon May 12 03:13:11 CDT 2008

You could try it this way:

=3DSUMPRODUCT((A1:A100=3D"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

On May 12, 8:55=A0am, stretch <stre...@discussions.microsoft.com> wrote:
> I have a worksheet were I want to count the number of times a number large=
r
> 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!
>
> =A0 =A0 =A0 =A0 A =A0 =A0 =A0 =A0B
> 1 =A0 =A0May =A0 =A0 =A0 0
> 2 =A0 =A0Feb =A0 =A0 =A0 =A00
> 3 =A0 =A0May =A0 =A0 =A0 15
> 4 =A0 =A0March =A0 =A040
> 5 =A0 =A0May =A0 =A0 =A0 50

AdilsonSoledade
Mon May 12 06:05:01 CDT 2008

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

--
Adilson Soledade


"Pete_UK" wrote:

> 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
>
> On May 12, 8:55 am, stretch <stre...@discussions.microsoft.com> 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
>
>

stretch
Mon May 12 09:43:02 CDT 2008

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:B100>0))
>
> --
> Adilson Soledade
>
>
> "Pete_UK" wrote:
>
> > 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
> >
> > On May 12, 8:55 am, stretch <stre...@discussions.microsoft.com> 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
> >
> >