subtotal for text

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.

=subtotal(3,f4:f562)-subtotal(2,f4:f562)

?

Originally Posted by brokenbiscuits

=subtotal(3,f4:f562)-subtotal(2,f4:f562)

?

It als counts the blank cell (this blank cell is the formula)

=subtotal(3,f4:f562)-subtotal(2,f4:f562)-countblank(f4:f562)

?

Originally Posted by brokenbiscuits

=subtotal(3,f4:f562)-subtotal(2,f4:f562)-countblank(f4:f562)

?

It does not work for me and I got ######################## all the way.

Post a copy of your worksheet - makes it easier for everyone to understand exactly the problems you're having.

Originally Posted by Gunther Maplethorpe

Post a copy of your worksheet - makes it easier for everyone to understand exactly the problems you're having.

I have attached a worksheet which similar to my actual one.

Are we looking at cols B & C now (rather than the E & F you originally advised)?

=SUBTOTAL(3,C3:C14)-SUBTOTAL(2,C3:C14)-COUNTBLANK(C3:C14)

works for me in Cell C1

It does not work when i filtered out the blank cell in column B. I also have tried to filter only Jan and also does not work

Ah, I see what you mean now.

Could you not change the formula in C3:C14 to show zero rather than blank (and conditional format to hide zeroes if necessary)?

You could then use =SUBTOTAL(3,C3:C14)-SUBTOTAL(2,C3:C14)