| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
count formulas
How can I count nonblanks in column B only if column A contains certain value?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Intervals of 1 Numeric value in a Row and Return Count down Column | Excel Worksheet Functions | |||
| Array Formulas take waaaay too long... | Excel Worksheet Functions | |||
| Need Formulas for counting multiple conditions | Excel Worksheet Functions | |||
| Count IF Multipile Formulas | New Users to Excel | |||
| calculating formulas for all workbooks in a folder | Excel Worksheet Functions | |||
Linear Mode
