count formulas
 

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

count formulas
 

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

"cpy" wrote in message
...
How can I count nonblanks in column B only if column A contains certain
value?

count formulas
 

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
--
Brevity is the soul of wit.


"cpy" wrote:

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