Re-calculate sum after filter is applied.
 

Hello All,

Using excel, I have a list with a sum function at the bottom. The
problem is the sum total is not recalculating after the list has been
filtered. Is there anything I can do about this?

Thank you!

R

Re-calculate sum after filter is applied.
 

Are you using =sum() or =subtotal()

And do you have calculation set for automatic?
(Tools|Options|Calculation tab)

ryan99 wrote:

Hello All,

Using excel, I have a list with a sum function at the bottom. The
problem is the sum total is not recalculating after the list has been
filtered. Is there anything I can do about this?

Thank you!

R

--

Dave Peterson