SUBTOTAL(?) count all fields including blanks in a filtered range

Basically, I need to count all of the rows in a filtered table regardless of if a cell has a value or not. SUBTOTAL(3,[my range]) will get me a count of all of the visible cells containing values. But, it omits blanks. And some fields may be blank in any given row of the dataset.

I need this to be completely formula driven if possible.

SubtotalSample111.xlsx

Hi
if you want only text count in filter then try - if cell doesn't contain formula.
It will not count blank cell.

SUBTOTAL(3,D4:D13)

if you want only text count in filter then try - if cell contain formula.
Only you have to do is Given 0 in the place of "" blank (in the formula)
So 0 will be count by SUBTOTAL(2,D4:D13)

Final formula try this onAttachment 824043e -

SUBTOTAL(3,E4:E13)-SUBTOTAL(2,E4:E13)

Also unmark check box - so zero will not show in the cell.

Attachment 824042

Attached excel sheet for your ref.......

Thank you !
Meharban Singh Pal

[QUOTE=meharbanpal;5809629]Hi
if you want only text count in filter then try - if cell doesn't contain formula.
It will not count blank cell.

SUBTOTAL(3,D4:D13)

if you want only text count in filter then try - if cell contain formula.
Only you have to do is Given 0 in the place of "" blank (in the formula)
So 0 will be count by SUBTOTAL(2,D4:D13)

Final formula try this onAttachment 824043e -

SUBTOTAL(3,E4:E13)-SUBTOTAL(2,E4:E13)

Also unmark check box - so zero will not show in the cell.

Attachment 824042

Attached excel sheet for your ref.......

Thank you !
Meharban Singh Pal