G'day,
I have 6 lotto numbers in a row ranging 1 to 45.
I like a formula to SUM low number and SUM of high numbers.
Low numbers are 1 to 22
High numbers 23 to 45
Example: 1 12 20 23 24 25 so Low : High
1 12 20 sum 23 24 25 sum
I have over 1000 draws in the history.
I am no wiz in the art of excel formulas
Retired sparky who dabbles in lotto.
Thank you
Bookmarks