Forum Discussion
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?
6 Replies
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.
Fund Long Name Fund Short Name Fund Account # Bergmann & Wayland Scholarship BBAW EN001088 BU General Financial Aid BBUG EN001089 BU General Financial Aid BBUG EN001090 BU General Financial Aid BBUG EN001091 Burton Scholarship BBUR EN001092 Fellows Program Renewable BCF2 EN001093 Fellows Program Renewable BCF2 EN001094 Fellows Program Renewable BCF2 EN001095 Fellows Program Renewable BCF2 EN001096 Fellows Program Renewable BCF2 EN001097 Fellows Program Renewable BCF2 EN001098 Fellows Program Renewable BCF2 EN001099 Peter Dix Memorial Scholarship BDIK EN001100 Carolyn & Patrick Dolan Scholarship BDOL EN001101 Robert & Christina Seix Dow Scholarship BDW2 EN001102 Sajjad Ebrahim '73 Scholarship Fund BEBR EN001103 Fellows - Laidlaw Merit Fund BLW1 EN001104 Lord Irvine A.S. Laidlaw Scholarship BLW2 EN001105 Lord Irvine A.S. Laidlaw Scholarship BLW2 EN001106 Lord Irvine A.S. Laidlaw Scholarship BLW2 EN001107 MBA Scholarship BMBA EN001108 MBA Scholarship BMBA EN001109 MBA Scholarship BMBA EN001110 MBA Scholarship BMBA EN001111 F.K. Tang Scholarship BTNG EN001112 The Financial Planning Office wants to know:
1) How much was spent on scholarship?
2) How much was spent on need vs. merit aid?
***(Note --use only account numbers)
FYI: This is not school work or office work -- I am self-teaching myself how to use excel and Pivot tables and this is a sample and I need help with this?
