I still don't see an example pointed out on your sheet of what you're trying to automate.

I was thinking initially a COUNTIF() formula to tell you how many times the number 4 was drawn? =COUNTIF(D:H, 4)

Perhaps a smaller sheet with less data where you could easily write up your desired results manually so we see what you're after more clearly??