I once had a spreadsheet which used CountA() at the bottom of a column. The spreadsheet also had an autofilter on it. The CountA() formula had an extra bit in it so the correct total number was displayed when the filter was used.

Can anyone please remind me what the formula was?

Regards

Tyler

Don't panic!

I found it:

=SUBTOTAL(3,A2:A283)

(It wasn't CountA() at all!!!)

Regards

Tyler

Its sorta CountA as that is what the 3 stands for. :)

Brian

Its sorta CountA as that is what the 3 stands for. :)

Brian

Brian

Sorta CountA?

Please explain

Tyler

Sorry

sorta is shorthand slang for "sort of" because the 3 in Subtotal(3,...) indicayes that the Subtotal is to use the function CountA, 1 Average 2 Count etc, so your comment that it was not CountA afterall was .. well it sorta was CountA .:D

Brian

Um, well explained, sorta... :D

Howdy, Brian!

Hi Rich

This is one of those cases when you begin to wish that you had not made a comment.
BTW where is fly over territory?

Brian

Hi Rich

This is one of those cases when you begin to wish that you had not made a comment.
BTW where is fly over territory?

Brian

Hey Brian

Don't let my thickness put you off!!

Thanks for the clarification.

Regards

Tyler

Hi Rich

BTW where is fly over territory?

Brian

I live in Missouri (center of US), but in my traveling since becoming sem president (April 1), I have been in California (twice), Kansas, Iowa, Minnesota, Illinois, Indiana, Tennessee, Kentucky, Georgia, Florida. I just got home last night, and I go back to Indiana (via Iowa/Illinois) Saturday for our National Convention. Since Jan 1, I have driven 20,000 miles and flown about the same number.

I have had a total of 15 days home since April 1. I almost feel like the Scarecrow from Wizard of Oz: "Part of me is there, part over there.... I'm all over the place!"

Glad you are keeping such a low carbon footprint ;)

Missouri is not one of the states I have visited, still got quite a few to go.

Brian