Calculating Data with SUMIFS

[redcabo7]

I am looking to use SUMIFS with the following formula (E+G+J)/(K-C) with the criteria of column B. The data will keep growing with the criteria (column B) will repeat. I have the following formula but I keep getting errors. Thank you for your help!

=IFERROR((((IFSUMS('WindowCompliance (YTD)'!E:E,'WindowCompliance (YTD)'!B:B,'ScoreCard (YTD)'!A6)+IFSUMS('WindowCompliance (YTD)'!G:G,'WindowCompliance (YTD)'!B:B,'ScoreCard (YTD)'!A6)+IFSUMS('WindowCompliance (YTD)'!J:J,'WindowCompliance (YTD)'!B:B,'ScoreCard (YTD)'!A6))/IFSUMS('WindowCompliance (YTD)'!K:K,'WindowCompliance (YTD)'!B:B,'ScoreCard (YTD)'!A6)-IFSUMS('WindowCompliance (YTD)'!C:C,'WindowCompliance (YTD)'!B:B,'ScoreCard (YTD)'!A6)),0)

 

[Fluff]

Hi & welcome to MrExcel.
You have IFSUMS, rather than SUMIFS.

 

[redcabo7]

I'm no longer getting errors as I had too many () however now my formula is returning zero.

 

[redcabo7]

Hi & welcome to MrExcel.
You have IFSUMS, rather than SUMIFS.

I can't thank you enough. Today is my first day using the SUMIFS and have found it's power but looks like it got the best of me. Issue resolved. Thank you very much for the quick response and such a simple fix.

 

[Fluff]

You're welcome & thanks for the feedback.