I'm curious to know if it's possible to nest multiple SUMIFS in one formula. If so how would this be constructed? Thanks in advance.
I'm curious to know if it's possible to nest multiple SUMIFS in one formula. If so how would this be constructed? Thanks in advance.
Check this out once and see if it helps you!!!
http://www.officearticles.com/excel/...soft_excel.htm
Please acknowledge the response you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.
SUMIF and SUMIFS merely return a number. So, you can place the SUMIF/SUMIFS function in any other fucntion's parameter that expects a number, including other SUMIFS. I imagine you would most often use it to compare values (e.g. IF(B1>= SUMIFS(...), ..., ...) ).
Last edited by Whizbang; 10-28-2011 at 03:02 PM.
The only reason I ask is because I was wondering if it's possible to use SUMIFS in a way it wasn't intended. Like being able to use multiple criteria from *one* range.
Did you try it or better yet, post the formula you are trying with an explanation and we might be able to help?
One possible solution...
=SUMPRODUCT(SUMIF(A1:A10,{"Apple","Orange"},B1:B10))
Last edited by jeffreybrown; 10-28-2011 at 07:13 PM.
HTH
Regards, Jeff
You can have multiple criteria on a single range.
=SUMIFS(A:A,B:B,">=" & DateValue("01/01/2011"),B:B, "<=" & DateValue("12/31/2011")
You can use sumif to create multiple criteria and it works for both rows and columns. It is the superpower of Excel data extraction. I use sumif like an addict!
Wasn't this covered in your previous question here?
Can you be more specific about what you want to do this time, thanks
Audere est facere
From reading the linked post, I assume you are referring to summing bases on an "OR" condition.
E.G. Items in column = "Data 1" or "Data 2"
You can do this using SUMPRODUCT
=SUMPRODUCT((A1:A100="Data 1")+(A1:A100="Data 2"),B1:B100)
See this link for details on SUMPRODUCT
http://xldynamic.com/source/xld.SUMPRODUCT.html
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks