a simple workaround for using SUMIF with an OR condition:
- SUMIF returns a single Sum value from the Sum Range which matches the criteria set under Criteria. a work around is to use OR conditions in flower brackets separated by comma.
- in this case the formula returns the value for the first condition mentioned in the flower bracket. it is not an error. the formula returns other values too but in a array form. to capture the complete value result of the formula in a single cell you would have precede it with a SUM formula. so the final output would look like this:
SUM(SUMIF(Criteria Range,{Criteria1, Criteria2, .. CriteriaN}, Sum Range))
this functionality can be extended for SUMIFS formula as well!
- SUMIF returns a single Sum value from the Sum Range which matches the criteria set under Criteria. a work around is to use OR conditions in flower brackets separated by comma.
- in this case the formula returns the value for the first condition mentioned in the flower bracket. it is not an error. the formula returns other values too but in a array form. to capture the complete value result of the formula in a single cell you would have precede it with a SUM formula. so the final output would look like this:
SUM(SUMIF(Criteria Range,{Criteria1, Criteria2, .. CriteriaN}, Sum Range))
this functionality can be extended for SUMIFS formula as well!
No comments:
Post a Comment