Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula Help.
I need a way to have a formula sum 6 #'s out of a list of 18 based on a
random generated list. (B1:S1) hole # 1-19 (B3:S3) Player Score on that hole (Z3:Z8) Random holes picked based on par. I have tried the sumif function but it does not look at multiple cell at once. All the lookup funtions return errors. =SUMIF($B$1:$S$1,$Z$3:$Z$8,B3:S3)*3-$T$2 (this returns -60 when it should return a +15) I think I need to us a IF statement, but the problem with this is it could be that my IF staement would longer than the alotted 7 argumebnts. Any suggestions? Thanks -- Pete |
#2
|
|||
|
|||
=SUM(LOOKUP($z$3:$z$8,$b$1:$s$1,$b$3:$s$3))
array entered (ctrl+shift+enter) Ensure that the random numbers generated between z3:z8 are within the range 1-19(holes) otherwise you are going to get an error. "Pete" wrote in message ... I need a way to have a formula sum 6 #'s out of a list of 18 based on a random generated list. (B1:S1) hole # 1-19 (B3:S3) Player Score on that hole (Z3:Z8) Random holes picked based on par. I have tried the sumif function but it does not look at multiple cell at once. All the lookup funtions return errors. =SUMIF($B$1:$S$1,$Z$3:$Z$8,B3:S3)*3-$T$2 (this returns -60 when it should return a +15) I think I need to us a IF statement, but the problem with this is it could be that my IF staement would longer than the alotted 7 argumebnts. Any suggestions? Thanks -- Pete |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |