I have this formula in N37 =SUM(G37:M37)/5
If the above result is 0, I want to count the number of times a specific
code(PQ) is in a specific range on another worksheet, and in cell N38, I'd
like the result to be, if PQ occurs 2 times in that range, 2 PQ. And if not
0, then nothing.

Something like. If N370, countif(data!A1:A7*PQ*,"")
So the result in the sample would be 2 PQ
A
s
s
pq
pq
s
s
s

Thanks

Steve