|
|
#10
01-03-2024, 12:55 AM
|
|||
|
|||
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. 
|
| Tags |
| excel 2013 formula |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Formula Copy Row 2 Row But Next Column In Formula From Another Tab | TimG | Excel | 3 | 04-16-2018 09:20 PM |
 Formula Help
|
OTPM | Excel | 2 | 10-22-2017 06:38 AM |
|
Possible to use an existing vlookup formula to also insert correct info and trigger a SUM formula
|
innkeeper9 | Excel | 2 | 09-13-2016 08:59 PM |
| Need help with dragging a formula and changing a reference column as I drag the formula. | LupeB | Excel | 1 | 10-22-2015 03:02 PM |
|
Need help with formula
|
zachluke | Excel | 3 | 03-13-2014 11:15 AM |
Windows 8 
Office 2016
Threaded Mode