It's for a football pool and I told the guy I;d research and play around to
see if it's possible.
The spreadsheet looks like this:
NAME 16 15
Bob Pitts New England
Joe Seattle Minnesota

It goes 16 through 1
Say Bob gets them all right except 15 (which he picked New England to win)
he gets 121 (possible out of 136 points).
Bob is in row 2 and takes up 16 columns. Right now I do the math by hand. Is
there a way to assign a cell a number value even though a team name is
entered in it?
The ideal situation is to check after the games and delete the wrong entries
and then use a SUM at the end. But for that to work a row needs a value I
take it.
I am quite lost on what to do here.
I am open to other ideas as well!