counting cells that display data

obviously if one wants to count all cells that contain data they can use COUNTA, but what if i have a range of cells that contain IF formulas and only want to count the cells that display data?

presumably you'd have to use some variation of NOT(""), but i can't seem to make it work.

Possibly:

=COUNTIF(A1:A100,"?*")

Assuming A1:A100 formulae return text.... if not (ie return numbers) use COUNT... if mix of numbers & text

=COUNTA(A1:A100)-COUNTBLANK(A1:A100)

(this is because COUNTBLANK treats Null as Blank whereas COUNTA does not)

EDIT: re: mix you can also use SUMPRODUCT if preferred... =SUMPRODUCT(--(A1:A100<>""))