count formulas

[Guest]

How can I count nonblanks in column B only if column A contains certain value?

 

[Biff]

How can I count nonblanks in column B only if

column A contains certain value?

What's the "certain value" in column A?

=SUMPRODUCT(--(A1:A10=10),--(B1:B10<>""))

=SUMPRODUCT(--(A1:A10="some_text"),--(B1:B10<>""))

Or, C1 = some value

=SUMPRODUCT(--(A1:A10=C1),--(B1:B10<>""))

Biff

 

[Guest]

I would create a third helper column, in column C and run the following
formula down:

=IF(A1=[certain value],IF(NOT(ISBLANK(B1)),"Nonblank",""))

Then, count the number of "Nonblank" responses you get: =COUNTIF([range from
helper column]="Nonblank")

Dave