COUNTIFS Cross Sheet: 1 Column is blank and 1 Column is not blank

cyndi_walker108886

Hello,

I'm doing a master summary metrics sheet (in lieu of a summary sheet on the source sheet because I need to build graph charts in a dashboard).

I need to count blank cells in a specific column, but only if another column has text.

I'm using this formula:

Where Range 1 will indicate if a new submission has been received, and Range 3 will indicate if a group has confirmed the new submission. Right now, if I only count Blank cells in Range 3, it even counts the blank rows at the bottom of the sheet even though those rows don't have any new submissions - so this gives me a false count.

I thought I could course correct this by instead only count blank cells in Range 3 IF there was text in Range 1....but I keep getting #UNPARSEABLE and I feel like I've tried every combination of wording and parenthesis possible.

Any chance someone could help me understand what I might be doing wrong? I would sincerely appreciate it!!

Best,

Cyndi

cyndi_walker108886

I finally got it to work - realized I had one of my references pointing to a bad sheet / column. And I'm not able to delete my original post for some reason (only edit). I'm good!

Andrée Starå

Hi Cyndi,

Glad you got it working!

I hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Please help the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!