I need help with an excel formula

[Arin67]

I have added the sum of a few rows, how do I divide the number as well

[#2 · Accepted solution]

@Arin67 

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?

[#3]

@Subodh_Tiwari_sktneer 

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?

[#4]

@Arin67 

[#5]

@Arin67 

There is no Spent Amount column in the data set. How are you going to figure that out?

Can you please mock up the desired output manually to show the end result you are trying to achieve based on the data in the sample file?

[#6]

@Subodh_Tiwari_sktneer 

[#7]

@Arin67 

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.