I want my formulas to update when I sort the data, but they dont?

  • Thread starter Thread starter Jesse
  • Start date Start date
J

Jesse

My problem is that I have huge list of data, and I create formulas to figure
averages, etc. Then, I want to sort the data and have my averages update
based on only what is shown by my sort. Can I do this
 
My problem is that I have huge list of data, and I create formulas to figure
averages, etc. Then, I want to sort the data and have my averages update
based on only what is shown by my sort. Can I do this
Click to expand...

Sort doesn't change what is shown, just the order, so your calcs
shouldn't change. Do you mean you are filtering? Or should be
filtering? Use the SUBTOTAL function to show calculations for only the
visible (filtered) items. Read up on it in Help for how to use it for
sum, average, count, etc.
 
Back
Top