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