excelidiothelpme
New Member
- Joined
- Feb 22, 2022
- Messages
- 18
- Office Version
- 2016
- Platform
- Windows
| SUMIFS Not Working.xlsx | |||||||
|---|---|---|---|---|---|---|---|
| B | C | F | |||||
| 1 | MTD13 | ||||||
| 2 | 2022 FIN YEAR | ||||||
| 3 | 31/03/2021 | ||||||
| 4 | |||||||
| 5 | SALES | #VALUE! | |||||
Current vs Prev Detailed | |||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| F1 | F1 | =HLOOKUP($F$3,TB!$AO$3:$BX$296,294,FALSE) |
| F3 | F3 | =D3-365 |
| F5 | F5 | =SUMIFS(TB!D4:BX292,TB!B4:B292,'Current vs Prev Detailed'!B5,TB!D296:BX296,'Current vs Prev Detailed'!F1) |
| SUMIFS Not Working.xlsx | |||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | |||
| 2 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | ||||
| 3 | SUMMARY | 29/02/2020 | 31/03/2020 | 30/04/2020 | 31/05/2020 | 30/06/2020 | 31/07/2020 | 31/08/2020 | 30/09/2020 | 31/10/2020 | 30/11/2020 | 31/12/2020 | 31/01/2021 | 28/02/2021 | 31/03/2021 | ||
| 84 | SALES | - | -5 000 000 | -6 000 000 | |||||||||||||
TB | |||||||||||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| D2:P2 | D2 | =D296 |
| C3:P3 | D3 | =E3-E1 |
Cell F8 Value Error:
=SUMIFS(TB!D84:BX292,TB!B84:B292,'Current vs Prev Detailed'!B8,TB!AO2:BX2,'Current vs Prev Detailed'!F1)
