Solved

Excel details required

Posted on 2013-01-11
5
333 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

863 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now