Formula Help.

[Guest]

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

 

[N Harkawat]

=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.