your workbooks calculation may be set to manual.
go to Tools Options Calculation tab and click Automatic and Ok
and apply different filters to check for the answers.

Stgeorge Wrote:
Thanks for repying to this.

If I filter the data I can get a subtotal at the bottom - however when
I
filter using another criteria the subtotal seems to stay associated
with the
original data and gives me an incorrect summation for the new visible
data.

"Bob Phillips" wrote:

Why do you not want to use SUBTOTAL, it does what you want?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Stgeorge" wrote in message
...
I have a large spreadsheet that I am using multiple drop downs in
to sort
for
different scenarios. I do not want to use the general data
subtotal
command
but each time I sort I want to get a total for the visible cells -
how do
you
do this?





--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=573876