Hello!
I'm relatively to Excel and working on a lotto number generator for some fun, while also learning some more about Excel and formulas etc.
I've been able to put most of it together from searching and try and testing, but this one aspect, which seems like it should be easy, has been eluding me for days!
All I need to do quite simply is find the correct formula to calculate all odd numbers that appear in the table of lotto numbers for each week from 1-15, 16-30 and 31-45. This formula will show the summary for the entire table.
so there will be 3 separate formulas obviously, one for each section. I've tried combining the Sumproduct and MOD formula (counting odd numbers) with my countifs (between ranges 1-15 inclusive) but either receive an error or incorrect values.
Not sure if perhaps I need to use a VBA function for this particular task?
appreciate any advice or tips!
Thanks
Craig
Bookmarks