Hello,
Could someone please tell me how to use sumif function, if possible, when sum range is different than criteria?
Here's the simplified version of the table I imported.
1-15-2014 8-57-28 AM.jpg
And here's what I want to get(column B only):
BANKOFFI600 $600.00
BAYVRETI600 $100.00
BAYVRETI600 $300.00
Thank you
Last edited by inincubus; 01-15-2014 at 01:27 PM.
snap shots and your explanation aren't sufficient for most people to figure out your problem. Attaching a spreadsheet w/sufficient data to see the issue would be more helpful. Go advanced and manage attachments to do that.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Thank you for the advice. I've attached the excel file.
If you are willing to relocate the totals to a different spot, either of these (cols J and K) would work.
There are hundreds of those, so that's not feasible.
Thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks