Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula needed
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) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula needed
=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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Help Needed! | Excel Worksheet Functions | |||
Excel formula to copy/paste formula needed please. | Excel Discussion (Misc queries) | |||
Formula help needed | Excel Discussion (Misc queries) | |||
Formula needed | Excel Discussion (Misc queries) | |||
Formula help needed | Excel Worksheet Functions |