Solved

Adding Cells based on a category in Excel

Posted on 2011-03-24
2
279 Views
Last Modified: 2012-05-11
Hi,

I have a basic excel question.  I've got a spreadsheet with two columns. One is dollar amounts and the other is category. I have 4 categories that I'm putting the dollar amounts into. For example,

Office Supplies
Meals
Advertising
Telephone

I am trying to figure out how to automatically total the dollar values for each category.  It should be something straight forward like total all dollar values in column A that have "meals" listed in column B for the same row.

The purpose here is that I have months of credit card statements that I need to go through to and break down in categories. I can get them in Excel but the charges are all mixed together and are currently not groups in any category.   If I can add a category column to that spreadsheet and then have it total them it would be a tremendous time saver as there will probably be about 25 categories for each statement and a few hundred charges for each month.  I've attached a basic sample sheet showing what I'm would like to do.

Thanks


SampleSheet.xls
0
Comment
Question by:djadambomb
[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
  • Learn & ask questions
2 Comments
 
LVL 33

Accepted Solution

by:
jppinto earned 500 total points
ID: 35206665
Just use a SUMPRODUCT formula like this:

=SUMPRODUCT(($B$2:$B$12=E3)*($A$2:$A$12))

Please check the attached file.

jppinto
SampleSheet.xls
0
 
LVL 50

Expert Comment

by:barry houdini
ID: 35206817
...or SUMIF....

In F3 copied down

=SUMIF(B:B,E3,A:A)

regards, barry
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

730 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