Forum Discussion

srenken's avatar
srenken
Copper Contributor
Oct 14, 2020
Solved

Add another column of criteria to SUMIF

I have inherited an excellent workbook and now I would like to add another column to my SUMIF criteria. I've tried a few different ways and keep getting formula errors about too many arguments, or m...
excel
  • HansVogelaar's avatar
    HansVogelaar
    Oct 14, 2020

    srenken 

    If you have multiple criteria, use SUMIFS instead of SUMIF. In SUMIFS, the sum range is the first argument:

     

    =SUMIF('MAIN DATA'!$AE$2:$AE$798,'MAIN DATA'!$M$2:$M$798,"Building",'MAIN DATA'!$E$2:$E$798,1)+SUMIF('MAIN DATA'!$T$2:$T$798,'MAIN DATA'!$Q$2:$Q$798,"Building",'MAIN DATA'!$E$2:$E$798,1)+SUMIF('MAIN DATA'!$X$2:$X$798,'MAIN DATA'!$U$2:$U$798,"Building",'MAIN DATA'!$E$2:$E$798,1)

HansVogelaar's avatar
HansVogelaar
MVP
Oct 14, 2020

srenken 

If you have multiple criteria, use SUMIFS instead of SUMIF. In SUMIFS, the sum range is the first argument:

 

=SUMIF('MAIN DATA'!$AE$2:$AE$798,'MAIN DATA'!$M$2:$M$798,"Building",'MAIN DATA'!$E$2:$E$798,1)+SUMIF('MAIN DATA'!$T$2:$T$798,'MAIN DATA'!$Q$2:$Q$798,"Building",'MAIN DATA'!$E$2:$E$798,1)+SUMIF('MAIN DATA'!$X$2:$X$798,'MAIN DATA'!$U$2:$U$798,"Building",'MAIN DATA'!$E$2:$E$798,1)

  • srenken's avatar
    srenken
    Copper Contributor
    Oct 20, 2020

    HansVogelaarThank you...I have this working now!!

  • srenken's avatar
    srenken
    Copper Contributor
    Oct 15, 2020

    Thanks, I will give that a try!

    HansVogelaar 

Resources