Let's say we want to count that are pseudo-blank. Formulas returning blank:

Enter this UDF:

Function fakeblank(r As Range) As Integer
Dim r1 As Range
For Each r1 In r
If r1.HasFormula Then
If Len(r1.Value) = 0 Then
fakeblank = fakeblank + 1
End If
End If
Next
End Function


use it like:

=fakeblank(A1:A50)

It will count cells containing stuff like:
=IF(1=1,"","")

If you are not familiar with UDFs, see:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

--
Gary's Student


"IntricateFool" wrote:

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?