I can't seem to figure out to cause an IF formula to utilize 'blank' as a referenced criteria. Here is a simplified version of the problem:
Column A
Criterion = 1
Criterion = 2
Criterion = 3
Criterion = Blank
=countif(Range,[criterion]) - this works for rows 1 - 3
=countif(Range, "") - this...