| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count empty cells with a specific term
Hi I want to count the number of empty cells in column d if column a=x
what formula should I use then? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count empty cells with a specific term
try
=SUMPRODUCT(--(a2:a22="x")*--(TRIM(d2:d22)="")) -- Don Guillett Microsoft MVP Excel SalesAid Software "FreddieP" wrote in message ... Hi I want to count the number of empty cells in column d if column a=x what formula should I use then? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count empty cells with a specific term
Do you need the double unary minus if you use * for multiplication, Don?
-- David Biddulph "Don Guillett" wrote in message ... try =SUMPRODUCT(--(a2:a22="x")*--(TRIM(d2:d22)="")) -- Don Guillett Microsoft MVP Excel SalesAid Software "FreddieP" wrote in message ... Hi I want to count the number of empty cells in column d if column a=x what formula should I use then? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count empty cells with a specific term
All seem to give the same ans.
=SUMPRODUCT((a2:a22="x")*(TRIM(d2:d22)="")) =SUMPRODUCT(--(a2:a22="x")*--(TRIM(d2:d22)="")) =SUMPRODUCT(--(a2:a22="x"),--(TRIM(d2:d22)="")) -- Don Guillett Microsoft MVP Excel SalesAid Software "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... Do you need the double unary minus if you use * for multiplication, Don? -- David Biddulph "Don Guillett" wrote in message ... try =SUMPRODUCT(--(a2:a22="x")*--(TRIM(d2:d22)="")) -- Don Guillett Microsoft MVP Excel SalesAid Software "FreddieP" wrote in message ... Hi I want to count the number of empty cells in column d if column a=x what formula should I use then? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count empty cells with a specific term
The extra double unary minuses won't do any harm.
=SUMPRODUCT(--(a2:a22="x")*--(TRIM(d2:d22)="")) is the same as saying =SUMPRODUCT(-1*-1*(a2:a22="x")*-1*-1*(TRIM(d2:d22)="")) -- David Biddulph "Don Guillett" wrote in message ... All seem to give the same ans. =SUMPRODUCT((a2:a22="x")*(TRIM(d2:d22)="")) =SUMPRODUCT(--(a2:a22="x")*--(TRIM(d2:d22)="")) =SUMPRODUCT(--(a2:a22="x"),--(TRIM(d2:d22)="")) -- Don Guillett Microsoft MVP Excel "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... Do you need the double unary minus if you use * for multiplication, Don? -- David Biddulph "Don Guillett" wrote in message ... try =SUMPRODUCT(--(a2:a22="x")*--(TRIM(d2:d22)="")) -- Don Guillett Microsoft MVP Excel SalesAid Software "FreddieP" wrote in message ... Hi I want to count the number of empty cells in column d if column a=x what formula should I use then? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting (for cells containing specific term) | Excel Worksheet Functions | |||
| Count Only Empty Cells AFTER Cells with Data | Excel Worksheet Functions | |||
| count for empty cells | Excel Discussion (Misc queries) | |||
| count non empty cells if other cell has certain value | Excel Discussion (Misc queries) | |||
| Filter/find/isolate one specific term? | Excel Worksheet Functions | |||
Linear Mode
