Help with Lotto Analysis

kpm30519

New Member
Joined
Nov 9, 2018
Messages
22
Hi--

I have a list of all winning lotto numbers, along with the days they were picked. I'd like to see how many total times each number (1-39) has hit on a given day of the week (Sun-Sat.)

Here's my sample data:

<!doctype html>
<html lang="en">


Excel 2013/2016
ABCDEFGH
1DrawDraw DayDraw DateDraw1Draw 2Draw 3Draw 4Draw 5
21002Sun8/4/199626153338
31003Mon8/5/199659152930
41004Tue8/6/1996828313235
51005Wed8/7/1996411132528
61006Thu8/8/19961112173032
71007Fri8/9/199646142439
81008Sat8/10/199646101438
91009Sun8/11/199668143032
101010Mon8/12/19961117222839
111011Tue8/13/19961528293039
121012Wed8/14/1996611223031
131013Thu8/15/1996910323334
141014Fri8/16/19965682134
151015Sat8/17/19961018212332
161016Sun8/18/199617323538
171017Mon8/19/1996613293436
181018Tue8/20/1996512222530
191019Wed8/21/19962122262937
201020Thu8/22/1996912161724
211021Fri8/23/1996911203135
221022Sat8/24/1996112162438
Sheet1

</body>
</html>

Here's an idea of what I'm looking for:
<!doctype html>
<html lang="en">


Excel 2013/2016
QRSTUVWXYZ
1123456789
2Sun14756
3Mon6286
4Tue8314
5Wed2732
6Thu099
7Fri85953
8Sat111023
Sheet1

</body>
</html>

As always, any help is greatly appreciated!
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.
This will give you a count, but probably won't help you win.
Copy formula down and across.
Excel Workbook
ABCDEFGHIPQRSTUVWXYZ
1DrawDraw DayDraw DateDraw1Draw 2Draw 3Draw 4Draw 5123456789
21002Sun8/4/199626153338Sun110002110
31003Mon8/5/199659152930Mon000011001
41004Tue8/6/1996828313235Tue000010010
51005Wed8/7/1996411132528Wed000101000
61006Thu8/8/19961112173032Thu000000002
71007Fri8/9/199646142439Fri000112011
81008Sat8/10/199646101438Sat100101000
91009Sun8/11/199668143032
101010Mon8/12/19961117222839
111011Tue8/13/19961528293039
121012Wed8/14/1996611223031
131013Thu8/15/1996910323334
141014Fri8/16/19965682134
151015Sat8/17/19961018212332
161016Sun8/18/199617323538
171017Mon8/19/1996613293436
181018Tue8/20/1996512222530
191019Wed8/21/19962122262937
201020Thu8/22/1996912161724
211021Fri8/23/1996911203135
221022Sat8/24/1996112162438
Sheet
 
Upvote 0
Thanks for the attempt, but all I get are 0's. Also, my spreadsheet is +/- 10000 lines. I changed the formula to this:

=SUMPRODUCT(--($B$2:$B$8180=$Q2)*($D$2:$H$8180=R$1))

but no joy, results are still 0.
 
Upvote 0
Whoops-- My Days were set as "=C2" and formatted as text. I changed them to pure text and it seems to work fine!!

Thanks for your help!
 
Upvote 0
You're welcome. Thanks for the feedback and good luck with lotto.
 
Upvote 0

Forum statistics

Threads
1,223,243
Messages
6,170,964
Members
452,371
Latest member
Frana

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top