Here is a formula which works with any Excel version from ~15 latest years, and don't need Ctrl+Shift+Enter.
This formula don't work without quarter column. And I had to add an additional pair of checks to avoid Q4 from 2023 counted into Q4 from 2024.
The only way to avoid using quarter column is probably go even more back, and instead SUMIFS and COUNTIFS to use SUMPRODUCT, where instead of column values you could check expressions for those columns! But I think, keeping the quarter column (and hide it) is easier way.
|