Brian Barker wrote:
At 14:56 26/09/2009 -0500, Wade Smart wrote:
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.
I fear you are contradicting yourself here. Your suggested formula
*counts* the wins, whereas what you ask for later is the *sum of the
point scores* for those wins. But you can do either, of course.
If I understand you correctly, you can count the wins with
=COUNTIF(D2:D7;"=3")
and you can sum them with either
=COUNTIF(D2:D7;"=3")*3
or
=SUMIF(D2:D7;"=3")
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
Brian, you were thinking X when I was thinking Y :D
The names of the teams are in column A and the game dates are in row 1
with the point value of each game in every other column.
But just before you posted I swapped everything around, dates in Col A
and Teams in Row 1 and then with your answers, which by the way I was
just trying to figure out countif myself, things cleared right up :D
I really appreciate having groups like this because, while doing this
volunteer work which takes hours and hours of time I find myself asking
question of how can I do this more efficiently and what I learn here I
will absolutely use again and again.
So, thanks :D!
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]
