Sumifs vs averageifs

[joeltes]

Can AVERAGEIFS work the way SUMIFS works in this example? (SUMIFS example works)
=SUM(SUMIFS('PAST YEAR'!F:F,'PAST YEAR'!D:D,NJIL!A:A,'PAST YEAR'!A:A,{"IL","1"})))
=SUM(AVERAGEIFS('PAST YEAR'!F:I,'PAST YEAR'!D:D,NJIL!A:A,'PAST YEAR'!A:A,{"IL","1"})))

 

[iliace]

It looks like you have more columns of your AVERAGEIFS function than you do in your SUMIFS. Any ...IFS() function will only work with a single column. You cannot say F:I, it has to be F:F.

 

[Aladin Akyurek]

Can AVERAGEIFS work the way SUMIFS works in this example? (SUMIFS example works)
=SUM(SUMIFS('PAST YEAR'!F:F,'PAST YEAR'!D:D,NJIL!A:A,'PAST YEAR'!A:A,{"IL","1"})))
=SUM(AVERAGEIFS('PAST YEAR'!F:I,'PAST YEAR'!D:D,NJIL!A:A,'PAST YEAR'!A:A,{"IL","1"})))

No, that is mathematically no.

But you can do:

=SUM(SUMIFS('PAST YEAR'!F:F,'PAST YEAR'!D:D,NJIL!A:A,'PAST YEAR'!A:A,{"IL","1"}))/
     
SUM(COUNTIFS('PAST YEAR'!F:F,'PAST YEAR'!D:D,NJIL!A:A,'PAST YEAR'!A:A,{"IL","1"}))
​​

​

​