Page 1 of 1

[Solved] Multiple calculations of columns of data

PostPosted: Sun Dec 09, 2018 4:12 am
by gehrig38
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
vista calc.png
vista calc.png (2.4 KiB) Viewed 390 times

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

Re: Not sure there's a solution here...

PostPosted: Sun Dec 09, 2018 4:26 am
by robleyd
It's not quite clear to me exactly what you are trying to achieve, and your image doesn't really help.

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

I think you are saying that you want individual sums of each column? But then your next need is totally not clear to me. Perhaps you could upload a sample spreadsheet - NOT an image - showing the type of data you are working with and the structure of the data, together with an example of the results you are trying to get, someone might be able to make suggestions.

Re: Multiple calculations of columns of data

PostPosted: Sun Dec 09, 2018 4:55 am
by RusselB
the number of columns I grab the values from, so it would be the columns values / sum of the total cells

Are you getting numbers from more than one column? Your picture only shows one column.
The sum of the values divided by the number of values in the column is easily done using the AVERAGE function
But your statement about "number of columns" makes me think you have multiple columns... in which case, if you want the average of the columns, you'll need to sum each column, then average the sums.

Re: Multiple calculations of columns of data

PostPosted: Sun Dec 09, 2018 5:01 am
by gehrig38
First off thanks for the quick reply!
I need to grab a column of numbers and then have that TOTAL divided by the number of cells I took the data from. The image above there are 18 cells with values.
I need a cell that takes those 18 numbers and "knows" to divide that total by "18" since that was the number of cells used to get that total.

I will be entering new data daily. In the way of more "actual scores" and I just want to be able to do what I did the first time, grab all the cells from before, plus the new values, and have that value updated to reflect the new totals and the new average.
Thanks again for being so quick to reply.

Re: Multiple calculations of columns of data

PostPosted: Sun Dec 09, 2018 5:04 am
by gehrig38
Holy crap. Was it really that easy?
=average()?
Sorry for wasting your time:)
Again I sincerely appreciate you replying so quickly.

Re: Multiple calculations of columns of data

PostPosted: Sun Dec 09, 2018 5:11 am
by gehrig38
One more question if I may?
Longshot but worth a try I guess.
Say I import a large swath of data. Players, statistics and what not.
Does OO have the ability to take that data and 'arrange' it with similar data on that sheet AND other sheets.
For example:
I have Sidney Crosbys season totals to date, home and away and all stats relevant that I use.
Does OO have the ability to take new data I import and parse that out to the current data?
If he plays a road game and I import stats, he has 5 shots, 1 goal, 2 assists
If I set it up would the program be able to add 5 shots, 1 goal and 2 assists to Crosbys ROAD GAME totals?
I am pretty sure I know the answer but felt I'd ask anyway
Again I appreciate you taking the time

Re: Multiple calculations of columns of data

PostPosted: Sun Dec 09, 2018 6:15 am
by RusselB
For all that, technically yes Open Office can.
However it'd be easier using Base, the database component, rather than Calc where you are starting from