software

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 gt;0.

Thanks for your help in advance !!!

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

and copy down on Sheet1

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Matthewquot; gt; wrote in message
...
gt; I wish to know the best way of getting a result for the following :-
gt;
gt; I have a column of names on sheet A Column A.
gt; I want to count the number of times the name occurs on Sheet B Column
gt; A...BUT also need the following extra condition...Only count if Sheet B
gt; Column B gt;0.
gt;
gt; Thanks for your help in advance !!!
Thanks Bob!

quot;Bob Phillipsquot; wrote:

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