Forum Discussion

Arin67's avatar
Arin67
Copper Contributor
Nov 15, 2019
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  
excel
  • Subodh_Tiwari_sktneer's avatar
    Subodh_Tiwari_sktneer
    Nov 15, 2019

    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?

Subodh_Tiwari_sktneer's avatar
Subodh_Tiwari_sktneer
Silver Contributor
Nov 15, 2019

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?

Arin67's avatar
Arin67
Copper Contributor
Nov 15, 2019

Subodh_Tiwari_sktneer 

Fund Long NameFund Short NameFund Account #
Bergmann & Wayland ScholarshipBBAWEN001088
BU General Financial AidBBUGEN001089
BU General Financial AidBBUGEN001090
BU General Financial AidBBUGEN001091
Burton ScholarshipBBUREN001092
Fellows Program RenewableBCF2EN001093
Fellows Program RenewableBCF2EN001094
Fellows Program RenewableBCF2EN001095
Fellows Program RenewableBCF2EN001096
Fellows Program RenewableBCF2EN001097
Fellows Program RenewableBCF2EN001098
Fellows Program RenewableBCF2EN001099
Peter Dix Memorial ScholarshipBDIKEN001100
Carolyn & Patrick Dolan ScholarshipBDOLEN001101
Robert & Christina Seix Dow ScholarshipBDW2EN001102
Sajjad Ebrahim '73 Scholarship FundBEBREN001103
Fellows - Laidlaw Merit FundBLW1EN001104
Lord Irvine A.S. Laidlaw ScholarshipBLW2EN001105
Lord Irvine A.S. Laidlaw ScholarshipBLW2EN001106
Lord Irvine A.S. Laidlaw ScholarshipBLW2EN001107
MBA ScholarshipBMBAEN001108
MBA ScholarshipBMBAEN001109
MBA ScholarshipBMBAEN001110
MBA ScholarshipBMBAEN001111
F.K. Tang ScholarshipBTNGEN001112
   

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?

    • Subodh_Tiwari_sktneer's avatar
      Subodh_Tiwari_sktneer
      Silver Contributor
      Nov 15, 2019

      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?

Resources