Excel_Mike
New Member
- Joined
- Feb 14, 2025
- Messages
- 2
- Office Version
- 365
- Platform
- MacOS
I'm trying to track product sales and am not sure the best approach to take for the output table formula.
I want to display the sales per product (E3:E10) with a column for each month, only counting sales between the dates starting with the later of Start or Alternate Start (Column A or B) and ending with End Date (Column C). Daily sales per product fluctuate, many of the time periods are partial months, and I'd like to be able to continue adding new month's data & output column in an ongoing basis.
I was planning to use something like SUMIFS(XLOOKUP()) but I'm not finding an elegant way to apply the logic needed with multiple criteria like this.
I want to display the sales per product (E3:E10) with a column for each month, only counting sales between the dates starting with the later of Start or Alternate Start (Column A or B) and ending with End Date (Column C). Daily sales per product fluctuate, many of the time periods are partial months, and I'd like to be able to continue adding new month's data & output column in an ongoing basis.
I was planning to use something like SUMIFS(XLOOKUP()) but I'm not finding an elegant way to apply the logic needed with multiple criteria like this.