To do multi-criteria or multi-region summing in sumifs, you can use multiple criteria and or multiple regions to specify your data range.
Here's an example of how:
Let's say you have the following data:
If you want to claim quantity and sell quantity for all products with dates between "2023-01-01" and "2023-01-02" with product as "Product A", you can use this formula::
=sumifs(c:c, a:a, "Product A", b:b, ">=2023-01-01", b:b, "<=2023-01-02")In this example, we use two conditions: the product is "Product A" and the date is between "2023-01-01" and "2023-01-02". These conditions correspond to each other
a:awithb:bRange.
If you want to request and sell quantity for all products with dates between "2023-01-01" and "2023-01-02" with products as "Product A" or "Product B", you can use the following formula::
=sumifs(c:c, a:a, "Product A", b:b, ">=2023-01-01", b:b, "<=2023-01-02") +sumifs(c:c, a:a, "= Product B", b:b, ">=2023-01-01", b:b, "<=2023-01-02")In this example, we use two separate sumifs functions to sum the products as "product A" and "product B", respectively. Each sumifs function has two conditions, which correspond to:
a:awithb:bRange.
Note: In the sumifs function, each condition must be marked with an equal sign (), and the wildcard () to match any character.