Thursday, July 4, 2013

yogi_Set Up A Running Total Of Payout For Matching Lottery Numbers (-5 for no match)

                                          Google Spreadsheet   Post  #1272
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jul 03, 2013
user Matthew Lehr (http://productforums.google.com/forum/?zx=j2xg0kd6omac#!category-topic/docs/spreadsheets/EcZJ0F296BU)
Need help comparing values from one cell to an entire column
Hello,

Hello,

I'm new here, and rather new to spreadsheets. What I am trying to accomplish is to check lottery numbers in a cell ... example (cell B3 against G3 through G12).  If it is a match then add the box payout to the running total in column D else subtract 5. You can see in D3 I was able to get a function that worked .. but would be cumbersome to do over and over and over. What kind of function would i need here?

Thanks so much in advance,
Matt

--------------------------------------------------------------------------------------------------------------------------------------------------------