Countif on filtered list or a range based on a value on another column

tdelarosa

I use the following function to count "=COUNTIF({Cell Range 2}, 0)" numerical values from a column.  However, I should only count the cell values when a cell value in the same respective row but in another column is blank.  Not sure how to proceed.

Andrée Starå

Hi,

Is this what you're looking for?

https://community.smartsheet.com/discussion/it-possible-count-blank-cell-only-text-filled-out-another-cell

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Mike Wilday

It sounds like you might want to use a COUNTIFS statement where you can indicate more than one condition. 

=COUNTIFS({Cell Range 2}, 0, [[[Create your other cross reference cell range here]]], ISBLANK(@cell))

You might also try the following formula cause off the top of my head I can't remember whether its cell or row, 

=COUNTIFS({Cell Range 2}, 0, [[[Create your other cross reference cell range here]]], ISBLANK(@row))