Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
ignore cells that are blank
Hello, I am using the following formula to count the number of occurrences of
my data being out of tolerance. My column of data (J46:J522) contains numbers and blank cells. My upper and lower tolerances are contained in cells L3 and L4. Therefore this equation is counting the number of data results less than the lower tolerance and higher than the high tolerance. This formula works great when L3 and L4 are bilateral (i.e. +/-.001). But a problem arises when L3 and L4 are unilateral (i.e. +.001/+.002). This is because the formula is treating blank cells as 0. Is there a way to make this formula ignore the blank cells? {=SUM(IF((J46:J522<L4)+(J46:J522L3),1,0))} |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Ignore Blank or 0 cells | Excel Worksheet Functions | |||
Ignore blank cells | Excel Discussion (Misc queries) | |||
ignore blank cells | Excel Discussion (Misc queries) | |||
How to ignore blank cells | Charts and Charting in Excel | |||
how do you ignore blank cells | Excel Discussion (Misc queries) |