excel-formulasumsumifs
Excel Sumifs with multiple criteria with OR
This has been driving me crazy all morning. Can someone help me please figure out how to use this sumifs with an OR?
Here is my formula:
=SUMIFS($H2:$H802,$A2:$A802, "COMPLETED ORDER",$B2:$B802, "Joe Johnson",$C2:$C802, "1/1/2018")
The formula seems to work the way it is, but what if I want the formula to choose either: COMPLETED ORDER OR (alternatively) CONFIRMATION RECEIVED?
Solution
You could use data validation to control the contents of a cell (I used E2 on the sheet) with the two conditions and just reference E2 in your existing formula instead of the text "completed order" etc.
You can either build the list directly in the data validation or you can reference a list on the sheet. You could also use this for the list of names that you want to work with...
- SUM of 2-way Weighted Grid in Excel
- Indexing folder content by alphabetical order in Excel
- How to consume data of 1 column based on other column
- VBA or formula to repeat a list of items, and for each repeated list, add a location name from a separate locations list
- How to match large data on excel based on some criteria?
- EXCEL Search of multiple possible strings of text
- VLOOKUP Returns 0 even though there is a value in the line below the first result
- transpose a table with multiple values in excel
- Apply FILTER formula to array (and use filter criteria on specific column in the array)
- Excel function to construct an array from values without VBA
- Excel - Aggregate dynamically values in a Table using array formulas (MAP, BYROW, CHOOSECOLS, TEXTJOIN, LAMBDA, FILTER, HSTACK) in a single Cell
- EXCEL: How do I return multiple columns using XLOOKUP, when the lookup_value is a range?
- Filtering an Array (not Range) based on a SUM of CHOOSECOLS applied to it
- Add rows to table produced with filter function based on additional argument
- Spill formula on % calculation
- Epoch Unix Value formula
- SORT formula with empy column in data range and descending order based on another column (not the first column in the data range)
- Update the nth element of an array on Excel using formulas
- Is there a way to Indirectly call an array of Table names?
- Power Query Dynamic Column Reference
- Excel(VBA) Formula in added column needing logical workaround
- Converting Feet-Inches to Inches Excel
- Daytime and Nightime Occurance Duration of an Event
- compile error : Ambiguous name detected: Worksheet_Change
- Excel - Formula to see if IP address is contained within list of subnets
- How to find duplicate values in one column while checking if a condition in another column is met
- How to update excel formula to work for all columns continuously to the right and not just the current 2 it's set up for
- How to do consecutive subtraction of adjacent columns and return the result concatenated in cell with comma separator?
- In Excel, create table showing the row,column of the cells in another table
- How to reliably increment a Character+Numeric value in excel