Forum Discussion
Seignix
Sep 08, 2022Copper Contributor
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
- Sep 08, 2022
=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.
Detlef_Lewin
Sep 08, 2022Silver Contributor