MS Excel

[Swill21]

G'day everyone. I've made a very simple spreadsheet to monitor the season for a sporting team. I'm having trouble with a function or formula to allow cumulative adding of cells.

This is what I would like to do. When I put a figure into B6 I would like that figure to be added to give me a total in H6. For example, this week I would put the number 8 into B6, then next week I would put the number 7 into B6. I want this to add up to 15 in H6. Can this be done and if so what is the formula? No one on this side of the world seems to know, so any help will be greatly appreciated.

Thanks for your time.

 

[bunker]

You always want the total to be 15 in H6? If so, you don't need a formula, just put in 15!

If you have a bunch of cells you want to add together you put this in H6:

=B6+C6+A4 etc....

 

[Swill21]

B6 is the only cell I'm using for data input. Is there a cumulative function so I can put data into B6 all the time and have it add up in H6? I'm just lazy and don't want to do the adding myself!

 

[OZEE]

I don't think you can do that because it'd create a circular-error. I.e. you'd be using a cell to define itself... your formula in h6 would be =h6+b6. Excel won't let you do that.

What you probably need to do if you're stuck with excel is to make column a the value for game 1, columb b the value for game 2, etc... then you can easily sum 'em up into h6.

 

[Mavrick007]

Why not do it in multiple columns? You can have a new column for each week.

Carry over the previous weeks numbers to the new column but keep it so that when you add B6 (or C6, or D6, etc), it changes the value in H6 (or I6, or J6, etc) to be updated. Then when you want, you can even find out what the previous week's totals were or any totals for other weeks. That's what I would do.

 

[Swill21]

 

[kranky]

I don't know if you bumped this for more input, but it can't be done for the reasons OZEE and Mavrick007 pointed out.

 

[ojai00]

I don't think you can do this on a single sheet, but you could do this across multiple sheets by using 3D cell reference. For instance, sheet 1 would be Week1, sheet 2, would be Week2, etc. The last sheet would be Total or something like that. The formula to add B6 across multiple sheets is =sum(week1:weekx!b6), where "x" is the last week. Hope this helps.