Login required to started new threads
Login required to post replies
I have a log in Excel. I have figured out how to have the row add up hours & minutes for the week. (ie for each sport)
I want the column to then give me a running total of volume from the rows. For each day and cumulative for the week.
I hope this makes sense!
If your minutes are in "A" and there are 17 entries
=A1+A2+A3+A4+A5+A6+A7+A8+A9+A10+A11+A12+A13+A14+A15+A16
----------------------------------------------------------
What if the Hokey Pokey is what it is all about?
=SUM(A1;A17)
there are TONS of other complicated tricks, but this might get you started
Hmm, not working. It does not help I know about zero about Excel!
That equation should have a colon (not a semi-colon) in the middle. Like this:
=sum(a1:a17)
The colon indicates a range, i.e. everything from one cell to another. The way I do a running total is:
Say your row totals are in column F. Then in G1 type =f1. Then in g2 (next row down, same column) type =f2+g1. That is, the total of the cell above, and the cell to the left. After that just copy and paste that cell (g2) down, one row at a time. Excel will figure it all out.
I hope this isn't too confusing.
Good Luck,
Jim
Just use the sigma button and you can drag the cursor over whatever range you want totaled.
The approach you are using to add each row (by sport) across should work to add each column (day) down. Is the problem in the format of the cell that contains the column total?
Last edited by:
Wags: May 2, 05 10:15