Forum Discussion
Solved
SumIfs Help
I am getting errors using the sumifs function. See attached file. Appreciate any help. Thank you.
If adjust formula to your ranges it'll be
=SUMPRODUCT('IS Detail By Company Base A (2)'!$C$10:$AK$950*('IS Detail By Company Base A (2)'!$A$10:$A$950=$C8)*('IS Detail By Company Base A (2)'!$C$3:$AK$3=E$6))Please check attached
Sum range in SUMIFS shall be 1D range, not 2D. Try to use SUMPRODUCT instead, like
=SUMPRODUCT('IS Detail By Company Base Accou'!$E$10:$AK950*('IS Detail By Company Base Accou'!$A$10:$A$950=$C8)*('IS Detail By Company Base Accou'!$E$3:$AK$3=E$6))
SergeiBaklan I had tried your suggestion, but wasn't able to get it to work either. are you able to make adjustments to the file and repost? I just need to sum by country listed.
Thanks.
If adjust formula to your ranges it'll be
=SUMPRODUCT('IS Detail By Company Base A (2)'!$C$10:$AK$950*('IS Detail By Company Base A (2)'!$A$10:$A$950=$C8)*('IS Detail By Company Base A (2)'!$C$3:$AK$3=E$6))Please check attached
SergeiBaklan Yes, that works! Thank you!!
bb94twins , you are welcome