Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I count conditional blank cells?
I want to count blank cells in one column where a certain value exists in
another column. DCOUNT and COUNTIF don't work for this purpose. For example, I want to count the blank cells in column B where the Cells in Column A equal "John": A B 1 John 5 2 John 3 John 7 4 Mike 1 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I count conditional blank cells?
Try something like this:
C1: =SUMPRODUCT((A1:A100="John")*ISBLANK(B1:B100)) Change range references to suit your situation. Does that help? *********** Regards, Ron XL2002, WinXP-Pro "Bruce Henson" wrote: I want to count blank cells in one column where a certain value exists in another column. DCOUNT and COUNTIF don't work for this purpose. For example, I want to count the blank cells in column B where the Cells in Column A equal "John": A B 1 John 5 2 John 3 John 7 4 Mike 1 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I count conditional blank cells?
Bruce, =SUMPRODUCT((A1:A4="John")*(ISBLANK(B1:B4))) Regards, Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=527608 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
count number of cells | Excel Worksheet Functions | |||
Generating truly blank cells | Excel Worksheet Functions | |||
enter numbers in blank cells | Excel Worksheet Functions | |||
Counting blank and filled cells within a range. | Excel Discussion (Misc queries) | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) |