Forum Discussion

bb94twins's avatar
bb94twins
Copper Contributor
Aug 23, 2019
Solved

SumIfs Help

I am getting errors using the sumifs function.   See attached file.   Appreciate any help.   Thank you.
SUMIFS
  • SergeiBaklan's avatar
    SergeiBaklan
    Aug 26, 2019

    bb94twins 

    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

excelgeek's avatar
excelgeek
Copper Contributor
Aug 23, 2019

bb94twins Can you upload the sample file? It would be helpful to see the tabs and arrays in your spreadsheet. Happy to take a look. 

Resources