ChetanPuri
Board Regular
- Joined
- Sep 5, 2018
- Messages
- 70
- Office Version
- 365
- Platform
- Windows
Hello Excel Gurus,
Just need a favour wondering why my sumifs with EOM doesn't work. Any help would be greatly appreciated.
Just need a favour wondering why my sumifs with EOM doesn't work. Any help would be greatly appreciated.
Book8 | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | |||
1 | |||||||||||||
2 | Start Dat Sum Of values | 31-Jan-19 | 28/02/2019 | Mar | |||||||||
3 | 0 | 0 | 0 | ||||||||||
4 | |||||||||||||
5 | |||||||||||||
6 | |||||||||||||
7 | |||||||||||||
8 | 6-Jan-19 | 17-Jan-19 | 15-Feb-19 | 23-Jan-19 | 17-Feb-19 | 23-Mar-19 | 10-Jan-19 | 25-Feb-19 | |||||
9 | 6555 | 4688 | 3275 | 2160 | 2404 | 3866 | 6649 | 5763 | |||||
10 | |||||||||||||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
D3:F3 | D3 | =SUMIFS($B$9:$I$9,$B$8:$I$8,">="&D2,$B$8:$I$8,"<="&EOMONTH(D2,0)) |