Lottery Simulation

[gzhelev]

Hi I've created a lottery simulator and I need help with some formulas. By pressing F9 on attached sheet you get a new set of random numbers for 3 months of every day play (that costs $90). I need a formula which adds $90 after each three month iteration to the cost column. Then I need a formula which picks up the winners from the three months (they are 1s as opposed the losers which are 0s). That formula must add $500 to the total of winnings. See my spreadsheet, its attached, includes all the details.

Thanks!

George

[windy58]

Using your sample sheet this will add 500 to I7 when a 1 appears in any of the month columns (placed in I7)
=IF(COUNTIF(E5:G33,1),I7+5,I7)
If no 1's are found it returns the current value of I7

When does the Cost cell need to change?
Does it increment like the winnings?

[gzhelev]

Thank you windy58. Yes the cost cell increments every time regardless of winning or losing. I applied the formula to the cost as well and it works the way I want it too.

Thanks for the help!

George

[windy58]

Glad I could help

Windy