2

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.

Functionality
Industry
Department

Comments

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))