count formulas

B

Biff

How can I count nonblanks in column B only if
column A contains certain value?
Click to expand...

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
 
D

Dave F

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
 
Top