null values returning 0

[dmheller]

Here is the equation
=1440-SUM(IF(ISNUMBER('Line 3'!$D$4:$D$44903),IF(INT('Line 3'!$D$4:$D$44903)=INT('Line 3 calc Sheet'!B3),--(('Line 3 data copy'!$E$4:$E$44703>220)+('Line 3 data copy'!$F$4:$F$44703>220)+('Line 3 data copy'!$G$4:$G$44703>220)+('Line 3 data copy'!$H$4:$H$44703>220)>0))))
CTR+****+Enter
So this is counting the min that any number is greater than 220 and subtracting it from 1440

Its looking up dates and then E,F,G,H are numbers
The equation works for what I am looking for except one problem. Sometimes within the data (numbers) there is bad data that says NULL. The equation treats this as nothing and counts it as greater than 220 I guess. How do I fix it so I can see there is NULL values? Any help would be great.
For example, I have 7 min of data that say Null and for my equation it returns 1433 or 1440-7 when it should return 1440 as 0 times the data gets above 220

thanks

 

[barry houdini]

Try adding ISNUMBER checks like this:

=1440-SUM(IF(ISNUMBER('Line 3'!$D$4:$D$44903),IF(INT('Line 3'!$D$4:$D$44903)=INT('Line 3 calc Sheet'!B3),--(('Line 3 data copy'!$E$4:$E$44703>220)*ISNUMBER('Line 3 data copy'!$E$4:$E$44703)+('Line 3 data copy'!$F$4:$F$44703>220)*ISNUMBER('Line 3 data copy'!$F$4:$F$44703)+ ('Line 3 data copy'!$G$4:$G$44703>220)*ISNUMBER('Line 3 data copy'!$G$4:$G$44703)+('Line 3 data copy'!$H$4:$H$44703>220)*ISNUMBER('Line 3 data copy'!$H$4:$H$44703)>0))))

 

[dmheller]

Thank you that works to solve that problem. Now I just have to find a way to find the Null values within the data set. Probably use filters, but if you know a way to search a column for that, that would be awesome. Or just search a column for the is not a number and I can find the Null value.