Excel formula

[Dean Schmaus]

I'm trying to create an auto-count feature for a points system. 1st = 6
points, 2nd = 4 points, 3rd = 3, 4th=2, 5th=1. The points will all be in a
single row that could span 40 columns. Some cell may have points, some may
not. Any idea of a formula that I could put in the total field that would
calculate every result?

 

[Simon]

I'm trying to create an auto-count feature for a points system.  1st = 6
points, 2nd = 4 points, 3rd = 3, 4th=2, 5th=1.  The points willall be in a
single row that could span 40 columns.  Some cell may have points, somemay
not.  Any idea of a formula that I could put in the total field that would
calculate every result?

SUM function works, or do you want Coutn as stated.
CountA? .Column.Count?

 

[Dean Schmaus]

I think I'll have to put an IF statement in there somewhere. For example, if
the person gets 1st place, they get 6 points, 2nd place is 4 points, etc.
This strategy is the same for every cell in the row.

 

[Simon]

I think I'll have to put an IF statement in there somewhere.  For example, if
the person gets 1st place, they get 6 points, 2nd place is 4 points, etc. 
This strategy is the same for every cell in the row.






- Show quoted text -

Thats correct, depends if you want to show that.

 

[Dean Schmaus]

I guess I'm looking for some assistance writing the formula. I know I'll
have to say that IF C5="1st", then add 6,OR IF C5=2nd, then add 4, etc. I
just don't know how to put it all together accurately.

 

[Simon]

I guess I'm looking for some assistance writing the formula.  I know I'll
have to say that IF C5="1st", then add 6,OR IF C5=2nd, then add 4, etc.  I
just don't know how to put it all together accurately.






- Show quoted text -

Oh I see what you mean, yes that would be fin, possibly conditional
format or Vlookup. Can you only use one like?

=IF(A1=1, 6, "")

This means, if A1 = 6 (6 points for coming 1st, a 6 is displayed
otherwise nothing, is this what you are after?).

You're on the wrong board though mate , this is using code with Visual
Basic.