This formula helps to sumup based on multiple criteria. It is same as sumif but sumif support only one condition whereas sumif support multiple conditions
=SUMIFS(sumrange, criteriarange1, criteria1,criteriarange2, criteria2, criteriarange3, criteria3, ....)
In example in the screenshot above the sumifs is calculating based on two criteria first is invoice number and the second is product type.
No comments:
Post a Comment