The article below explains two approaches.
One approach is based on theSUMIFS function, which can sum numeric values based on multiple criteria.
The second approach is based on theSUMPRODUCT function, which allows a more flexible solution.
For convenience, both solutions use thenamed rangesamount(C5:C16) anddate(B5:B16).
See below for more information.
SUMIFS solution
TheSUMIFS functioncan sum values in ranges based on multiple criteria.
Notice we need toconcatenatethe dates tological operators, as required by the SUMIFS function.
Using EDATE is a simpler and more robust solution.
The TRUE value in this array corresponds to the only date in January 2022.
This array is then multiplied by the values inamount.
For a side-by-side comparison of formulas vs. pivot tables, see this video:Why pivot tables.
in a text string with the number format of your choice.
