Cumulative Totals

[fredmr]

I have the following:

A = 1st number entry (0 to say 625)
B = 2nd number entry ( " )
C = 3rd number entry ( " )
D = SUM OF ENTRIES (A->C) per session =IF(SUM(A5:C5)=0,"",SUM(A5:C5))
E = NUMBER OF ENTRIES (A->C) per session =IF(COUNT(A5:C5)=0,"",COUNT(A5:C5))
F = AVERAGE NUMBER per session (A->C) =IF(D5="","",D5/E5)

I want to compute to following:

G = ROLLING TOTAL of "E" per Session for an extended period.
H = ROLLING TOTAL of "F" per Session for an extended period.
I = ROLLING TOTAL AVG of "E & F" per Session for an extended period.

Such that: Initially "A->F" show BLANK prior to ANY entries,
ONLY numbers show for entries in "AND/OR" "A->C",
for each ROW (1 to say 126).

I cannot seem to form equations for “G, H, & I” that satisfy all conditions as they either:
*come up TRUE,
*come up FALSE,
*come up 0,
*come up #VALUE,
*come up #DIV/0,
*come up with a miscount or “no-count”.

I guess this is kind of like keeping Bowling Scores??

Can anyone help me out??

Thanks in advance,

Fred

[Carim]

Hi,

Do you mind uploading a zipped copy of your spreadsheet ...?

[fredmr]

No I don't mind, I will in the next few minutes.

Fred

[fredmr]

You should now have "TestSheet_1.zip

Note: I may be away from the computer for a while.

Thanks,

Fred

[Carim]

Hi Fred,

Make sure to attach your file with the
Manage Attachments button, located in the Additional Options section ...

[fredmr]

Hi Carmin,

I thought I did the first time but here it is again.

Thanks.

Fred

[Carim]

Hi again,

When you sum column A,B,C does it add up to a year ...?
Your formulas in columns H, J, K must be corrected to avoid circular references, or if you prefer a cell which includes itself in the calculation ...

[fredmr]

A -> C sum up upon each individual SET of entries through the point of Calculation. If I want to enter an aditional SET, I delete the old entries, enter new ones, and re-calculate. I continue this until I want to start a brand new baseline (a new data collection START point.)

The other three rows must each add information from the new data set to the their own previous collective data and recompute a new collective answer. I am aware that this means that they have to add additional data to themselves.
I also want them to go to BLANK if I am starting a new baseline, a new data collection START point. Hope that you understand what I am getting at. (Improper language, but, Oh Well---)

Fred

Carim,

It's now about 9pm here & I have to leave until somewhere around 2pm tomorrow. I will check back in at that time. So you have some time to work with some other questions if you wish. At any rate, thanks for the time spent so far.

Fred

Carim,

I am now back on line. You seem to have been a busy boy/girl (??). I followed the "Burrelly" thread and you do good work.

Fred

[fredmr]

Carim,

I am now back on line. You seem to have been a busy boy/girl (??). I followed the "Burrelly" thread and you do good work.

Fred