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))
Hi SergeiBaklan ,
I attempted to replicate the formula you had created for me into another file, but apparently I am doing something wrong. Would appreciate your help again if you could please review the attached and advise on what I need to adjust. The cells are on the first tab highlighted in green.
Thank you.