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
=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.
3 Replies
- OliverScheurichGold Contributor
=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.
- SeignixCopper ContributorThanks it worked
- Detlef_LewinSilver Contributor