Forum Discussion
Solved
I need help with an excel formula
I have added the sum of a few rows, how do I divide the number as well
It's not clear exactly what you are trying to achieve.
Is it possible for you to upload a sample file (not an image) to show us what you are trying to achieve?
Please have a look at the Pivot Table inserted on the Master Sheet and let me know if that is what you are trying to achieve.
Before inserting the Pivot Table, I converted the data range on Master Sheet into an Excel Table and named it "FundData" so that if you add/delete data in the Table, Pivot Table will be updated after being refreshed.