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?