Excel details required

Hi,

I use excel sheet to keep a track of my spending under certain categories.
I want the sum of the category on the right side mentioned category under Category total.
Please find attached excel sheet.
Spendings-2013.xlsx
abhinav4Asked:
Who is Participating?
 
WebDevEMCommented:
Hi... perfect timing!  I was just updating my own version of the same spreadsheet this morning.  The formula you want to use is SUMIF().  I've attached an updated version of your sheet.
Spendings-2013.xlsx
0
 
NBVCCommented:
Try:

=SUMIF($A$15:$A$37,G16,$D$15:$D$38)

copied down
0
 
Patrick MatthewsCommented:
For something like this I would definitely recommend a PivotTable.

The following article will provide some guidance on creating your PivotTable, as well as how to ensure that your PivotTable automatically updates as you add o remove source data:

http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/A_3172-How-to-Automatically-Update-Your-PivotTables-and-PivotCharts.html
0
 
abhinav4Author Commented:
Thanks buddy
0
 
WebDevEMCommented:
No problem at all - I think we should both look into the Pivot Table idea though.  Everywhere I looked for the formula for my own spreadsheet was pointing me to them, but it seemed like more work than I wanted to get into.  I think it could be worth learning though, since not all spreadsheets will be as simple as just a few categories and Pivot Tables are supposed to be very powerful.

Glad my formula helped!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.