Count as 1

[deemer98]

In the range of cells I8:R8, I11:R11, I14:R14, I17:R17,I20:R20

I want cell J25 to count as "1", any cell that has a number in that range except "0".

Thanks

 

[Scott Huish]

I'm glad you got it sorted but you should always add additional info and clarification to the original post. Your question will bump back up to the top of the list when you do this and your question will be clearer to everyone.