So, you want to count EMPTY cells and exclude cells with formula blanks?

=SUMPRODUCT(--(ISBLANK(A1:A10)))

Biff

"IntricateFool" wrote in message
...
I am trying to count blank cells in a column that contain a formula, but
when
I do excel counts the formulas as well even though they are blank...

Currently my formula looks like:

=IF(B43=INDIRECT("Medicaid_Medical!"&I43&"$2"),COU NTA(OFFSET(INDIRECT("Medicaid_Medical!"&I43&"$2"), 2,0,47,1))/COUNTA(States_Medical),0)

The problem is the cells in the column it is counting contain an if
statement to see what cells are blank. Any way to look over the blank
cells
and keep the if statement?