Alright. Im really getting stuff done today learning to use more of
these functions
Based on the questions and answers from earlier and I moved on to tackle
more difficult things.
Right working now on team standings in different clubs in the league.
I have six teams (A2 to A7), D2 hold the points (3win, 1tie, 0loss).
D2, h2, J2, K2, L2, N2, etc are date columns holding the points value.
X2 to X7 is the Wins column, Y2 - 7 is the loss and z2-7 is the tie.
So, what Im attempting to do is,
=IF(D2=3, 1,"") - which works.
But what I want to do is added up each column of wins.
So, if D2 = 3 then x2 is three after the first game.
Next week if F2 = 3 then x2 would equal 6.
Im just not sure how to go about that.
Wade
--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
