Excel Cumulative Addition

Frisbee

Simple enough query here I think.

I have two cells B5 and C5

How exactly do I get C5 to equal B5+C5?

I'm using it for a Fantasy Football template where I want to add 'This Week's Score'(B5) to the 'Total Score'(C5).

Cheers

p.s. I'm using openoffice if that makes a difference

Hagar

You can't. That's a circular reference.

Give us some more details.

I'll make some assumptions:

Points for Wk 1 go in B5, running total in C5
Points for Wk 2 go in B6, running total in C6
Points for Wk 3 go in B7, running total in C7
.
.
.
Points for Wk 52 go in B57, running total in C57

Put your points in b5,b6,b7 etc

Formulae for running total column as follows
c5=b5
c6=b6+c5
c7=b7+c6
c8=b8+c7
c9=b9+c8
etc down to
c57=b57+c56

Hope that helps.

Frisbee

Hagar wrote: »

You can't. That's a circular reference.

Give us some more details.

I'll make some assumptions:

Points for Wk 1 go in B5, running total in C5
Points for Wk 2 go in B6, running total in C6
Points for Wk 3 go in B7, running total in C7
.
.
.
Points for Wk 52 go in B57, running total in C57

Put your points in b5,b6,b7 etc

Formulae for running total column as follows
c5=b5
c6=b6+c5
c7=b7+c6
c8=b8+c7
c9=b9+c8
etc down to
c57=b57+c56

Hope that helps.

Cheers Hagar, that's not quite what I was getting at though.
I didn't want to have a load of sub total columns.
So was hoping to just have two points columns per player.
One as 'This Weeks Points' and the other as 'Total'

Example:

John gets 5 points the first week. So:
This weeks points = 5
Total = 5

Second week John gets 3 points. So:
This weeks points = 3
Total = 8

Third week John gets 1 point. So:
This weeks points = 1
Total = 9


Is that possible?

Hagar

You have to store each week's point in a cell somewhere so that you can add them up.
You could always put your calculations 50 cells to the right so that they will be out of view.

Hagar

PM sent.

evilhomer

This might be of help http://office.microsoft.com/en-us/excel/HP011277801033.aspx

Frisbee

Cheers lads

PM Sent Hagar

amen

i think fantasty.premierleague.co.uk
allows you to manage custom fantasy leagues

I have no connection to this site

Frisbee

One more question on this lads.
How do I get a column to order itself by the highest numerical value?

For example if Column B+C have the following values:

(B5) John - (C5) 4
(B6) Conor - (C6) 13
(B7) Kev - (C7) 9
(B8) Alan - (C8) 4

How could I get the column to come out as:

Conor - 13
Kev - 9
John - 4
Alan - 4


Cheers

Evil Phil

Folks,

I'll remind you all of the rules regarding pm'ing each other in thread. i.e. You're not supposed to do it.

People will come across this thread via the search engines and hit a dead end.

E.P.

Hagar

My apologies. I initiated it, it wasn't the OP's fault. I just wanted to PM him a simple sheet without him having to make his, or my, email address public.


I have saved the sheet and fwiw I will make it available to anyone who PMs me for it.

Again sincerest apologies.

Frisbee

Evil Phil wrote: »

Folks,

I'll remind you all of the rules regarding pm'ing each other in thread. i.e. You're not supposed to do it.

People will come across this thread via the search engines and hit a dead end.

E.P.

Sorry Phil

Frisbee

Frisbee wrote: »

One more question on this lads.
How do I get a column to order itself by the highest numerical value?

For example if Column B+C have the following values:

(B5) John - (C5) 4
(B6) Conor - (C6) 13
(B7) Kev - (C7) 9
(B8) Alan - (C8) 4

How could I get the column to come out as:

Conor - 13
Kev - 9
John - 4
Alan - 4


Cheers

Can anyone help me with this?

Tails142

you can manually do a 'Sort' every time you update the table or use a 'Filter'.

F1