Calculating a auto filtered range
 

=subtotal(9,F6:F220)

change the f to the column that contains the values you want to sum

--
Regards,
Tom Ogilvy

"mdl2004" wrote in message
...
Hi can anyone help me!

I've inputed my customers total invoice information on excel and auto
filtered it to give me a summary by depot.

The range goes from a6 -a220 but when auto filtered some of the rows are
overlooked due to the summary. I've selected the total column but all that
does is add everything.
Is there a easier way to set up a calculation at the bottom of the page
that
adds up the sorted range based on the auto filter i've used.

Look forward to any comments!

Calculating a auto filtered range
 

Works perfect, cheers Tom!

"Tom Ogilvy" wrote:

=subtotal(9,F6:F220)

change the f to the column that contains the values you want to sum

--
Regards,
Tom Ogilvy

"mdl2004" wrote in message
...
Hi can anyone help me!

I've inputed my customers total invoice information on excel and auto
filtered it to give me a summary by depot.

The range goes from a6 -a220 but when auto filtered some of the rows are
overlooked due to the summary. I've selected the total column but all that
does is add everything.
Is there a easier way to set up a calculation at the bottom of the page
that
adds up the sorted range based on the auto filter i've used.

Look forward to any comments!