Solved

# Excel details required

Posted on 2013-01-11
337 Views
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.
Spendings-2013.xlsx
0
Question by:abhinav4
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points

LVL 23

Expert Comment

ID: 38767635
Try:

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

copied down
0

LVL 9

Accepted Solution

WebDevEM earned 500 total points
ID: 38767636
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

LVL 92

Expert Comment

ID: 38767729
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

Author Closing Comment

ID: 38767746
Thanks buddy
0

LVL 9

Expert Comment

ID: 38767826
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.

0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

### Suggested Solutions

This collection of functions covers all the normal rounding methods of just about any numeric value.
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to usâ€¦
###### Suggested Courses
Course of the Month4 days, 3 hours left to enroll