Forum Discussion

Seignix's avatar
Seignix
Copper Contributor
Sep 08, 2022
Solved

Help Needed with this SUMIFS

This is my SUMIFS =SUMIFS($D$2:$D$49611,$A$2:$A$49611,$I$2,$C$2:$C$49611,J1) It give zero. please Help
  • OliverScheurich's avatar
    Sep 08, 2022

    Seignix 

    =SUMIFS($D$2:$D$7,$A$2:$A$7,$I2,$C$2:$C$7,J$1)
    

    Enter "2020" in cell J1 and so on and the above formula works as intended.

     

Resources