We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

I want to include a row of added data automatically into my summary average row....it already does this for a summary column which is the product of another summary cell value and a constant...how do i do this?...d

asked 2020-09-09 00:53:46 +0200

davidbruner7 gravatar image

I am trying to add rows of data and have them automatically included into the summary data. Most of these functions are conditional, mainly "averageif"...how do I accomplish this task?

thank you,

David Bruner

edit retag flag offensive close merge delete


Could you explain in a bit more detail (Step by Step if possible) what you want to achieve? Providing an befor and after example ... is also an option, to show it.

igorlius gravatar imageigorlius ( 2020-09-09 01:12:57 +0200 )edit

Read these guidelines and ask a good question. In particular, make the title short.

gabix gravatar imagegabix ( 2020-09-09 08:08:04 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2020-09-09 01:57:07 +0200

newbie-02 gravatar image

if i'd understand your wish right:

(you have rows with data, and one row which averages for the respective column, you want to add a new column on top or bottom of the data? and it should become included in the averages?)

just add a new row with [alt-s - r - a] as the second or penultimate, then copy the content of the first to second or last to penultimate, and overwrite the first or last with the new data,

that way calc will do all neccessary adaptions to summary formulas for you,

note that columns that connect / calculate different rows - for example running totals - sometimes require special handling or corrections as inserting sometimes changes their references / referencing,

there are many! other ways, this one has proven to be simple and effective for me ...

P.S. 'solved marks' and 'likes' welcome,
click the grey circled hook - ✓ - top left to the answer to turn it green if the problem is solved,
click the "^" above it if you 'like' the answer,
"v" if you don't,
do not! use 'answer' to add info to your question, either edit the question or add a comment,
'answer' only if you found a solution yourself ...

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-09-09 00:53:46 +0200

Seen: 26 times

Last updated: Sep 09 '20