Hello community,
I am trying to sum values in column E
If column C is September
Also column C 2022
Until month everything was working fine, but when I added 1 more criteria ( Year ) i get error. Can anyone help me please?
=SUMPRODUCT(Sheet2!$E$2:$E$3000,--( TEXT(Sheet2!$C$2:$C$3000,"MMMM")=Dashboard!$K$2),--(YEAR (Sheet2!$C$2:$C$3000)=M2))
I am trying to sum values in column E
If column C is September
Also column C 2022
Until month everything was working fine, but when I added 1 more criteria ( Year ) i get error. Can anyone help me please?
=SUMPRODUCT(Sheet2!$E$2:$E$3000,--( TEXT(Sheet2!$C$2:$C$3000,"MMMM")=Dashboard!$K$2),--(YEAR (Sheet2!$C$2:$C$3000)=M2))