ExcelBanter - formula needed

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - formula needed (https://www.excelbanter.com/excel-discussion-misc-queries/239583-formula-needed.html)

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)

=COUNTIF(B4:D155,"0")+COUNTIF(F4:G155,"0")
--
David Biddulph

SuzyQ wrote:
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)