COUNT IF - MULTIPLE CRITERIA

M

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 !!!
 
B

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

Matthew

Thanks Bob!

Bob Phillips said:
=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)
Click to expand...
 
Top