Tom's Guide | Tom's Hardware | Tom's Games

Computing.Net > Forums > Office Software > MS Excel formula

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

MS Excel formula

Reply to Message Icon

Name: comom
Date: September 2, 2009 at 08:01:47 Pacific
OS: Windows Vista
Product: Microsoft Excel 2007
Subcategory: Microsoft Office
Tags: excel, formulas
Comment:

I have a spreadsheet with two columns, one for category, one for amount. I need to write a formula that will find all the values in category that match and add the corresponding amounts. Please help. Thanks



Sponsored Link
Ads by Google

Response Number 1
Name: DerbyDad03
Date: September 2, 2009 at 08:33:03 Pacific
Reply:

Look at the SUMIF function in Excel help.

You may want to start with an Advanced Filter to create a list of all the unique values in your category list and then reference that list with your SUMIF functions.

Give it a try and come on back if you need more help.

edited by moderator


0
Reply to Message Icon

Related Posts

See More


Use following form to reply to current message:

Login or Register to Reply
LoginRegister


Sponsored links
Ads by Google


Results for: MS Excel formula
Excel formula references problem www.computing.net/answers/office/excel-formula-references-problem/5265.html

MS Excel 2002 wont open a PDF link www.computing.net/answers/office/ms-excel-2002-wont-open-a-pdf-link/5209.html

MS Excel - Change text with IF www.computing.net/answers/office/ms-excel-change-text-with-if-/5644.html