Solved

Excel details required

Posted on 2013-01-11
5
336 Views
Last Modified: 2013-01-11
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
0
Comment
Question by:abhinav4
5 Comments
 
LVL 23

Expert Comment

by:NBVC
ID: 38767635
Try:

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

copied down
0
 
LVL 9

Accepted Solution

by:
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

by:Patrick Matthews
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

by:abhinav4
ID: 38767746
Thanks buddy
0
 
LVL 9

Expert Comment

by:WebDevEM
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.

Glad my formula helped!
0

Featured Post

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

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

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Article by: Leon
Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question