# Can you nest multiple SUMIFS into a formula?

1. ## Can you nest multiple SUMIFS into a formula?

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.

2. ## Re: Can you nest multiple SUMIFS into a formula?

Check this out once and see if it helps you!!!

http://www.officearticles.com/excel/...soft_excel.htm

3. ## Re: Can you nest multiple SUMIFS into a formula?

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(...), ..., ...) ).

4. ## Re: Can you nest multiple SUMIFS into a formula?

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.

5. ## Re: Can you nest multiple SUMIFS into a formula?

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))

6. ## Re: Can you nest multiple SUMIFS into a formula?

You can have multiple criteria on a single range.

=SUMIFS(A:A,B:B,">=" & DateValue("01/01/2011"),B:B, "<=" & DateValue("12/31/2011")

7. ## Re: Can you nest multiple SUMIFS into a formula?

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!

8. ## Re: Can you nest multiple SUMIFS into a formula?

Wasn't this covered in your previous question here?

Can you be more specific about what you want to do this time, thanks

9. ## Re: Can you nest multiple SUMIFS into a formula?

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

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1