Share via

How to calculate average using a reference cell

Anonymous
2022-04-12T00:13:16+00:00

Hello all,

I want to calculate the average value based on a cell with two upper and two lower cell numbers as shown in the below picture. I have lots of data and I want to refer image number so that it automatically takes the value next to the image number and calculates the average using two above and below cell values. is there any easy way to do that? Thanks in advance

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2022-04-12T09:58:31+00:00

Re: running average of five cells

This is the way I see it...

'---
Nothing Left to Lose

https://1drv.ms/u/s!Au8Lyt79SOuhZw2MCH7_7MuLj04?e=sAwbHU

(free excel programs)

Was this answer helpful?

1 person found this answer helpful.
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-04-12T01:53:53+00:00

    Hi Thokala, hope you're doing well. I’m Ian, and I’m happy to help you today.

    You can do Offset to get the two above and two below cell values to get the average of it. Please sample code below. In this case we are look the Average of C7 based on the values of C5,C6, C8, C9 columns

    =(SUM(OFFSET($C7, 1, 0, 2, 1)) +SUM(OFFSET($C7, -1, 0, -2, 1))) /4

    You can also do a simple formula below. You sum the 5 columns and subtract the value of the column you want to average.

    =(SUM($C5:$C9)-$C7)/4

    This is a user-to-user support forum and I am a fellow user.

    I hope this helps, but please let me know if you need anything else.

    Was this answer helpful?

    0 comments