So for the value of 1 in B7, you want to count the instances where the value of 17 (d7) occurs in range D7:D81?
Close, I do want to be able to count the number of times a number repeats/occurs in the range D7:H51
But B7 (the "B" Column) isn't a "Value" - More like an on/off switch - if there is a number there include that row in the search of the range. (And to number the 25 most recent entries)