For convenience, all data is in anExcel Tablenameddata.
This is a tricky problem, because the solution is not obvious.
The go-to function for conditional sums is theSUMIFS function.
However, when using SUMIFS with multiple criteria, all conditions must be TRUE.
One solution is to use an array constant with SUMIFS, then sum the results with the SUM function.
Another option is to use SUMIFS twice.
InLegacy Excel, you will need to enter as anarray formulawith control + shift + enter.
This is a flexible approach that works nicely in situations where SUMIFS can’t be used.
Note: in the current version of Excel you might use the SUM function instead of SUMPRODUCT.
Criteria can be applied to dates, numbers, and text.
for partial matching….
SUMPRODUCT Function
The Excel SUMPRODUCT function multipliesrangesorarraystogether and returns the sum of products.
MATCH supports approximate and exact matching, andwildcards(* ?)
Often, MATCH is combined with the…
Related videos
How to use the SUMIFS function
