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
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.
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 …