On Aug 6, 3:04*pm, Dean Schmaus
wrote:
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" wrote:
On Aug 6, 2:42 pm, Dean Schmaus
wrote:
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?

SUM function works, or do you want Coutn as stated.
CountA? *.Column.Count?- Hide quoted text -

- Show quoted text -

Thats correct, depends if you want to show that.