Hey guys and gals!
\1
I need something similar to a SumIf formula, but with two levels of ranges/criteria, and it doesn't appear as if nesting a SumIf within a SumIf is the way to go.
I'm sure Excel can complete this relatively simple task somehow, but i'm just not sure how!
All help is greatly appreciately.. thanks all!
Last edited by MacroPolo; 06-28-2012 at 10:21 AM.
Hi
Give a try to SUMIFS function.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Thanks, that seems like it will be the way to go, i'm just trying to understand how this formula works now
With SUMIF, the Sum range is the last argument. Just to confuse things, Microsoft made the Sum range the first argument in SUMIFS
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Would you like to upload a small sample workbook?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks