Forum Discussion

BDBonnett's avatar
BDBonnett
Occasional Reader
Oct 03, 2025

What is the formula for counting each number from 1to25 that hits from each drawing?

I want to calculate the daily numbers for cash25 lotto. The numbers are drawn on Monday, Tuesday, Thursday, and Friday of each week. Six number from 1 to 25 are drawn each time. I have 157 rows and 7 columns (A-G). The first column is the date and Columns B-G are each number that was drawn. I know I need to do a count in each column of the total times each number is drawn. What is the formula I should enter? Help, please!

 

 

 

community

1 Reply

  • OliverScheurich's avatar
    OliverScheurich
    Gold Contributor
    Oct 04, 2025
    =GROUPBY(TOCOL(B1:G157),TOCOL(B1:G157),LAMBDA(x,COUNT(x)),,0)

    This formula returns the intended result in my Excel online sample sheet.

     

Resources