detect in the yellow group the number of numbers drawn.

[jorel]

detect in the yellow group
the number of numbers drawn
and then add the amount
https://www.excelforum.com/attachmen...1&d=1607083560

[Pete_UK]

Use this formula in Q5:

=IF(COUNTIF($A5:$O5,Q$4),"x","")

(You may need to use semicolons ( ; ) instead of commas ( , ) in the formula, depending on your regional settings).

Copy the formula across into R5:Y5. Then you can use this formula in Z5:

=COUNTIF(Q5:Y5,"x")

Copy all those formulae down as far as you need them.

Hope this helps.

Pete