Count # Blank Cells if Adjacent Cells are Not Blank
Hi! I am creating a Dashboard within an Excel file to chart the data on a separate tab. I need help determining the formula for the following: If the date cells from A2 (ASA Notification) and B2 (ASA Response) are not blank, count B:B. This should return a single # of pending "ASA Responses from Column B.
if, by pending, you mean B is blank when A is not blank:
Please Login or Register to view this content.
Ben Van Johnson
That is exactly what I needed, THANK YOU!!
Can you help me understand how you came up with that formula so I can learn?
The first argument of the formula, i.e., --(A2:A9<>""), creates an array of true/false values base on the test criteria (<>"") and the "--" causes the true/false values to be converted to 1' or 0's.
get rows that are not blank in A2:A9
the second argument tests for blanks in column B, returning another range of True/False values:Please Login or Register to view this content.
the sumproduct function then multiplies the corresponding rows of each array and sums the resultPlease Login or Register to view this content.
Please Login or Register to view this content.
Last edited by protonLeah; 03-13-2024 at 02:51 PM.
This was extremely helpful, THANK YOU!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks