Hi guys,
First off I apologize for the awkward description in the title.
What I'm trying to do is this;
If I have a sheet that has two columns, A is the name of the store and B is the amount I spent.
ex.
Amazon $4.89
Market Basket $20.32
Amazon $49.99
market Basket $22.22
etc...
I'd like to easily be able to have a function just add all the Amazon prices (or Market basket etc)
Is there a function for this?
Drew
sounds like you want a sumif function, =SUMIF(range with the list, criteria like Amazon, range of cells to add)
see if that helps you.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Hello and welcome to the forum.
Yes there are two that come to mind --- SUMIF & SUMPRODUCT.
Formula:
Please Login or Register to view this content.Formula:Please Login or Register to view this content.
Dave
Thanks guys, works like a charm.
Drew
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks