COUNT IF - MULTIPLE CRITERIA

[Matthew]

I wish to know the best way of getting a result for the following :-

I have a column of names on sheet A Column A.
I want to count the number of times the name occurs on Sheet B Column
A...BUT also need the following extra condition...Only count if Sheet B
Column B >0.

Thanks for your help in advance !!!

[Bob Phillips]

=SUMPRODUCT(--(Sheet2!$A$1:$A$1000=A1),--(Sheet2!$B$1:$B$1000>0))

and copy down on Sheet1

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Matthew" <[email protected]> wrote in message
news:[email protected]...
> I wish to know the best way of getting a result for the following :-
>
> I have a column of names on sheet A Column A.
> I want to count the number of times the name occurs on Sheet B Column
> A...BUT also need the following extra condition...Only count if Sheet B
> Column B >0.
>
> Thanks for your help in advance !!!

[Matthew]

Thanks Bob!

"Bob Phillips" wrote:

> =SUMPRODUCT(--(Sheet2!$A$1:$A$1000=A1),--(Sheet2!$B$1:$B$1000>0))
>
> and copy down on Sheet1
>
> --
> HTH
>
> Bob Phillips
>
> (remove nothere from email address if mailing direct)
>
> "Matthew" <[email protected]> wrote in message
> news:[email protected]...
> > I wish to know the best way of getting a result for the following :-
> >
> > I have a column of names on sheet A Column A.
> > I want to count the number of times the name occurs on Sheet B Column
> > A...BUT also need the following extra condition...Only count if Sheet B
> > Column B >0.
> >
> > Thanks for your help in advance !!!
>
>
>