Re-calculate sum after filter is applied.

  • Thread starter Thread starter ryan99
  • Start date Start date
R

ryan99

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
 
Are you using =sum() or =subtotal()

And do you have calculation set for automatic?
(Tools|Options|Calculation tab)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum Function When Formula Produces #N/A 2
Access Sum function in an Access Form 1
filter macro 4
Is this an Excel bug and how do I report it? 3
Excel Excel 2007, Sum with criteria 1
Update Filter List AFTER Filter Applied 3
Pivot Table Calculated Fields 4
filter macro 3

Back
Top