### [Solved] Multiple calculations of columns of data

Posted:

**Sun Dec 09, 2018 4:12 am**Hey guys

First timer here.

I hope I can explain what I am looking for.

This picture is from a spreadsheet obviously.

Here is my goal.

I need to do a =sum and grab these columns and their values, and have that result in another cell. I can do that

Then I need that sum / the number of columns I grab the values from, so it would be the columns values / sum of the total cells I took the values from

THEN

I need to be able to import another batch of data at the end of the current set, and redo the math.

I'm fine if I need to redrag or redo the equation, but is there an actual way to do this?

Thanks in advance

Title Edited. A descriptive title for posts helps others who are searching for solutions and increases the chances of a reply [robleyd, Moderator].

First timer here.

I hope I can explain what I am looking for.

This picture is from a spreadsheet obviously.

Here is my goal.

I need to do a =sum and grab these columns and their values, and have that result in another cell. I can do that

Then I need that sum / the number of columns I grab the values from, so it would be the columns values / sum of the total cells I took the values from

THEN

I need to be able to import another batch of data at the end of the current set, and redo the math.

I'm fine if I need to redrag or redo the equation, but is there an actual way to do this?

Thanks in advance

Title Edited. A descriptive title for posts helps others who are searching for solutions and increases the chances of a reply [robleyd, Moderator].