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 |
=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 |
All times are GMT +1. The time now is 11:38 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com