Check for Number in one column - then count specific numbers in a range.

So........

The criteria is that column B has a value >0 and when this is met, then a calculation is performed.

In your example, for B7 (as 1>0 so criteria met) what's the calculation you want to happen?

I need to use the numbers in column "B" Only to "Authorize" searching D1:J75 for the number of occurrences of a specific number.

What is the specific number (in your example) that you want to count the instances of?

Multitasking badly so apologies if you clearly stated this earlier