countif?

[Paula]

I want to count data in column B if there is data in column A. If a
cell in a is blank then I don't want to count it.

7 s
4 s
3 s
s
2 s
2

3 s

I want to count the number of "s" I see in column b when there is a
number next to it in column a. The answer I look for is 5.

thank for help

 

[Roger Govier]

Hi

One way
=SUMPRODUCT(--($A$1:$A$1000<>""),--($B$1:$B$1000="s"))

 

[Guest]

=SUMPRODUCT(--(A1:A8<>""),--(B1:B8="s"))

 

[Paula]

=SUMPRODUCT(--(A1:A8<>""),--(B1:B8="s"))

Thank you and Roger much. work good

 

[Don Guillett]

Just in case there is a "dreaded space bar" or a letter in col A, try this
for NUMBERS only in col A.
=SUMPRODUCT(--(ISNUMBER($A$1:$A$1000)),--($B$1:$B$1000="s"))