AVERAGEIFS formula with average range depending on cell

**laura.gomper** · 08-20-2020, 05:37 AM

Hello guys!

I am a little bit lost and I even don't know if this is the correct forum to post my question. I am currently trying to use the AVERAGEIFs formula, but i would like the average_range to depend on a cell.

I have a worksheet called data where i have several columns with ranges... for example.... r_apples, r_oranges...

depending on what i want to average... i would like to write in the cell B5 for example: r_apples...

so in the formula =AVERAGIFS(B5,....other criteria). Is this possible? I haven't seen this question before and I have searched in all internet. Do you have any suggestion? I am pretty desperate!

Thank you in advance,

Laura

**bebo021999** · 08-20-2020, 05:41 AM

Welcome!
INDIRECT may helps, but I just guess, because there is no sample worksheet.
Could you pls send a sample worksheet?
Follow instruction on top of the page (in yellow banner)

**laura.gomper** · 08-20-2020, 05:47 AM

OMG... i have been looking for this during a while now and now it is solved so easily. Shame on me. Thank you so so so so much...

Laura.

**laura.gomper** · 08-20-2020, 05:49 AM

Where do i put this thread as solved? Not able to see it!

**José Augusto** · 08-20-2020, 05:53 AM

Or maybe

=AVERAGE(INDEX(B3:C6,0,MATCH(F3,$B$2:$C$2,0)))
where B3:C6 is data to average, B2:C2 are r_apples, r_oranges and F3 has the name of one that columns.

See the file