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 |
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 |
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 |
All times are GMT +1. The time now is 11:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com