AVERAGEIF array formula is only averaging the first column in average_range.

Hello Sig.
Welcome to the forum.

I've seen other people have this problem, but the solution has been to turn their normal formula into an array formula, which I have done to no avail.

Try array entering

Formula:

=AVERAGE(IF(D1:D38=F50,B1:C38))

Hello and welcome to the forum.

Try instead the array formula

Formula:

=AVERAGE((D1:D38=F50)*(B1:C38))*2

where the 2 is the number of columns in the range to be averaged.

I've rearranged my data and tried an alternate approach with the AVERAGEIFS formula. However, I am getting the #VALUE! error.

Here is the formula: =AVERAGEIFS(Toppers!C1:D460,Toppers!A1:A460,Calculator!B2,Toppers!B1:B460,Calculator!B3)

Referencing:
Attachment 631537 , Attachment 631538


I've read that my criteria_range and sum_range must be the same shape and size. I'm not sure if that is the issue though because when I modified my criteria ranges to be 2x460 that did not get rid of the #Value! error.


Thank you for your original reply, but this approach is better than my original one (so long as I can figure it out), so I started this before I saw anyone's reply. Hopefully you can help.

Would you upload the workbook please?

Caution is needed when averaging averages since most of the time it's not arithmetically correct.

It's difficult to know whether that applies in your case since you haven't supplied the workbook but i suggest you check.

Thanks for letting us know.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.