Count Only Positive Numbers With Another Condition

[Firas]

Assuming 2 columns of 100 rows each; the first contains the names John, Mary, Joe in random order. The second contains positive, zeros and negative numbers. What would be the formula to COUNT all of the positive numbers in column B that are associated with the name John in column A?
Thanks in advance.
Firas
<!-- / message -->

 

[Peter_SSs]

Welcome to the MrExcel board!

Try
=SUMPRODUCT(--(A1:A100="John"),--(B1:B100>0))

 

[Aladin Akyurek]

Assuming 2 columns of 100 rows each; the first contains the names John, Mary, Joe in random order. The second contains positive, zeros and negative numbers. What would be the formula to COUNT all of the positive numbers in column B that are associated with the name John in column A?
Thanks in advance.
Firas
<!-- / message -->

=SUMPRODUCT(
   --($A$2:$A$100=E2),
   --ISNUMBER($B$2:$B$100),
   --($B$2:$B$10 > 0))

where E2 houses a value like John.

 

[Firas]

Thank you both. The sum product will give add the values, but I need just to count them.

 

[Peter_SSs]

Thank you both. The sum product will give add the values, but I need just to count them.

Did you try the formula?

 

[Firas]

My bad. I just did and it worked. Thanks very much