Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Help... sorry posted in new Users too (accident)
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Help... sorry posted in new Users too (accident)
You will need a results row to compare to. You could use something like this
Name 16 15 ... 1 Total RESULTS Pitts New Eng ... Dallas =136 Bob Pitts New Eng ... Dallas formula enter the following formula (should be in R3 if I counted right) =SUMPRODUCT(B$1:Q$1,--(B$2:Q$2=B3:Q3)) and copy down entire list of names. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible? | Excel Worksheet Functions | |||
Recurring Excel Formula error - multiple users affected! | Excel Discussion (Misc queries) | |||
"Unable to set the Formula property of the Series class" with a tw | Charts and Charting in Excel | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
2 Nesting questions | Excel Worksheet Functions |