Hi,

Could you please advice how to do the subtotal for text?

I have tried

=SUBTOTAL(3,F4:F562). F is formatted as text

However, look like it does the total everything in my column. I would to get this work same as

=SUBTOTAL(2,E4:E562). E is formatted as DATE

Your comment will be very much appreciated.