I need to show a value in one cell based on a range of cells showing a value
0 but not the sum of those cells. IE I have cells range B4:D155 and F4:G155
from each of those cells I need to know if it has a value of 0 (I don't care
what the value is)

I need in another cell if(B40,1,0) + if(B40,1,0) ... + if (D1540,1,0) +
if (D1550,1,0) + ...(the second range) How can I accomplish this without
entering all of these as individual cells)