I understand what you suggested, however, it doesn't address the issue of the
result changing when applying filters to other columns in the spreadsheet.

I was able to get the total number of cells that contains, for instance
"DP*", however when I applied filters to another column the total number of
cells containing DP did not change.

"Dave Peterson" wrote:

=subtotal(9, f2:f11119)
Sums the values in those visible cells

If you look at Excel's help, you'll see that you have an option to Count Numbers
or Count (non-empty) in that range, too.



Irv wrote:

I tried that but it didn't work. =subtotal(9,f2:f11119) is what I used.

"Dave Peterson" wrote:

Take a look at =subtotal() in Excel's help.

Irv wrote:

I need to find a formula that counts the number of cells in a column that has
data (text, &/or number), but the kicker is I need that number to change when
I use filters.

--

Dave Peterson


--

Dave Peterson