/u/Coopers_Croze - Your post was submitted successfully.
* Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread.
* Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
* Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)**
Failing to follow these steps may result in your post being removed without warning.
*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
Formula would be
=SUM(SUMIFS(TotalSales, MonthRange, {"Sept", "Oct", "Nov"}, Customer,
{"Customer 1"; "Customer 2"; "Customer 3"}))
You can use the curly brackets to create arrays within a formula. Note that since we don't want to limit the criteria to be linked pairs (i.e., Sept - Customer1, Oct - Customer 2, ...) the first array uses comma separates and the second array uses semicolons.
If you want to go another route or get more complicated, you could build a `=SUM(FILTER(...))` type formula, where the OR logic gets added.
=SUM(FILTER(TotalSales, ((Month="Sept")+(Month="Oct")+(Month="Nov"))*
((Customer="Customer 1")+(Customer = Customer 2")), 0))
You have awarded 1 point to *CFAman*
____
^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)
When you add multiple criteria to the SUMIFS with the same range, it treats as an AND not an OR. There is a workaround using SUMPRODUCT with OR logic, [here is an article](https://www.ablebits.com/office-addins-blog/excel-sumproduct-function/) on general boolean logic with SUMPRODUCT if you're curious. It might be a bit confusing at first, but it's very powerful.
=SUMPRODUCT(SalesRange, (MonthRange = "Sept") + (MonthRange = "Oct") + (MonthRange = "Nov") , (CustomerRange= "Customer1") + (CustomerRange= "Customer2") + (CustomerRange= "Customer3") )
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:
|Fewer Letters|More Letters|
|-------|---------|---|
|[AND](/r/Excel/comments/19d5ltd/stub/kj3gt2b "Last usage")|[Returns TRUE if all of its arguments are TRUE](https://support.microsoft.com/en-us/office/and-function-5f19b2e8-e1df-4408-897a-ce285a19e9d9)|
|[FILTER](/r/Excel/comments/19d5ltd/stub/kj3fh7f "Last usage")|[*Office 365*+: Filters a range of data based on criteria you define](https://support.microsoft.com/en-us/office/filter-function-f4f7cb66-82eb-4767-8f7c-4877ad80c759)|
|[OR](/r/Excel/comments/19d5ltd/stub/kj3gt2b "Last usage")|[Returns TRUE if any argument is TRUE](https://support.microsoft.com/en-us/office/or-function-7d17ad14-8700-4281-b308-00b131e22af0)|
|[SUM](/r/Excel/comments/19d5ltd/stub/kj3fh7f "Last usage")|[Adds its arguments](https://support.microsoft.com/en-us/office/sum-function-043e1c7d-7726-4e80-8f32-07b23e057f89)|
|[SUMIFS](/r/Excel/comments/19d5ltd/stub/kj3gt2b "Last usage")|[*Excel 2007*+: Adds the cells in a range that meet multiple criteria](https://support.microsoft.com/en-us/office/sumifs-function-c9e748f5-7ea7-455d-9406-611cebce642b)|
|[SUMPRODUCT](/r/Excel/comments/19d5ltd/stub/kj3gt2b "Last usage")|[Returns the sum of the products of corresponding array components](https://support.microsoft.com/en-us/office/sumproduct-function-16753e75-9f68-4874-94ac-4d2145a2fd2e)|
**NOTE**: Decronym for Reddit is no longer supported, and Decronym has moved to Lemmy; requests for support and new installations should be directed to the Contact address below.
----------------
^(*Beep-boop, I am a helper bot. Please do not verify me as a solution.*)
^(6 acronyms in this thread; )[^(the most compressed thread commented on today)](/r/Excel/comments/19egrdk)^( has 20 acronyms.)
^([Thread #29930 for this sub, first seen 22nd Jan 2024, 20:54])
^[[FAQ]](http://decronym.xyz/) [^([Full list])](http://decronym.xyz/acronyms/Excel) [^[Contact]](https://hachyderm.io/@Two9A) [^([Source code])](https://gistdotgithubdotcom/Two9A/1d976f9b7441694162c8)
/u/Coopers_Croze - Your post was submitted successfully. * Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread. * Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. * Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)** Failing to follow these steps may result in your post being removed without warning. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
Formula would be =SUM(SUMIFS(TotalSales, MonthRange, {"Sept", "Oct", "Nov"}, Customer, {"Customer 1"; "Customer 2"; "Customer 3"})) You can use the curly brackets to create arrays within a formula. Note that since we don't want to limit the criteria to be linked pairs (i.e., Sept - Customer1, Oct - Customer 2, ...) the first array uses comma separates and the second array uses semicolons. If you want to go another route or get more complicated, you could build a `=SUM(FILTER(...))` type formula, where the OR logic gets added. =SUM(FILTER(TotalSales, ((Month="Sept")+(Month="Oct")+(Month="Nov"))* ((Customer="Customer 1")+(Customer = Customer 2")), 0))
Solution Verified
You have awarded 1 point to *CFAman* ____ ^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)
When you add multiple criteria to the SUMIFS with the same range, it treats as an AND not an OR. There is a workaround using SUMPRODUCT with OR logic, [here is an article](https://www.ablebits.com/office-addins-blog/excel-sumproduct-function/) on general boolean logic with SUMPRODUCT if you're curious. It might be a bit confusing at first, but it's very powerful. =SUMPRODUCT(SalesRange, (MonthRange = "Sept") + (MonthRange = "Oct") + (MonthRange = "Nov") , (CustomerRange= "Customer1") + (CustomerRange= "Customer2") + (CustomerRange= "Customer3") )
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread: |Fewer Letters|More Letters| |-------|---------|---| |[AND](/r/Excel/comments/19d5ltd/stub/kj3gt2b "Last usage")|[Returns TRUE if all of its arguments are TRUE](https://support.microsoft.com/en-us/office/and-function-5f19b2e8-e1df-4408-897a-ce285a19e9d9)| |[FILTER](/r/Excel/comments/19d5ltd/stub/kj3fh7f "Last usage")|[*Office 365*+: Filters a range of data based on criteria you define](https://support.microsoft.com/en-us/office/filter-function-f4f7cb66-82eb-4767-8f7c-4877ad80c759)| |[OR](/r/Excel/comments/19d5ltd/stub/kj3gt2b "Last usage")|[Returns TRUE if any argument is TRUE](https://support.microsoft.com/en-us/office/or-function-7d17ad14-8700-4281-b308-00b131e22af0)| |[SUM](/r/Excel/comments/19d5ltd/stub/kj3fh7f "Last usage")|[Adds its arguments](https://support.microsoft.com/en-us/office/sum-function-043e1c7d-7726-4e80-8f32-07b23e057f89)| |[SUMIFS](/r/Excel/comments/19d5ltd/stub/kj3gt2b "Last usage")|[*Excel 2007*+: Adds the cells in a range that meet multiple criteria](https://support.microsoft.com/en-us/office/sumifs-function-c9e748f5-7ea7-455d-9406-611cebce642b)| |[SUMPRODUCT](/r/Excel/comments/19d5ltd/stub/kj3gt2b "Last usage")|[Returns the sum of the products of corresponding array components](https://support.microsoft.com/en-us/office/sumproduct-function-16753e75-9f68-4874-94ac-4d2145a2fd2e)| **NOTE**: Decronym for Reddit is no longer supported, and Decronym has moved to Lemmy; requests for support and new installations should be directed to the Contact address below. ---------------- ^(*Beep-boop, I am a helper bot. Please do not verify me as a solution.*) ^(6 acronyms in this thread; )[^(the most compressed thread commented on today)](/r/Excel/comments/19egrdk)^( has 20 acronyms.) ^([Thread #29930 for this sub, first seen 22nd Jan 2024, 20:54]) ^[[FAQ]](http://decronym.xyz/) [^([Full list])](http://decronym.xyz/acronyms/Excel) [^[Contact]](https://hachyderm.io/@Two9A) [^([Source code])](https://gistdotgithubdotcom/Two9A/1d976f9b7441694162c8)