Hi everyone,
Help is needed.........

cells B5 to B40 may contain a number or be left blank--- cells O5 to
O40 may contain a number or be left blank.

I need to count the instances where a number appears in a cell B5 to
B40 and cells O5 to O40 example

cell B10 cell O10 cell z10
3 1 = 1 instance

cell B15 cell O15
7 1 = 1
instance so total would be 2 instances of criteria met.

Hope this is clear to someone who could help me with this.

Thanks in advance......