sum if number < 95

[dmheller]

All,
I have a sum if function
=SUM(IF(ISNUMBER('Line 4'!$D$4:$D$44903),IF(INT('Line 4'!$D$4:$D$44903)=INT('Line 4 calc Sheet'!B3),'Line 4'!$K$4:$K$44703<"95")))/60
So the first part is looking up a date and comparing the date.
The part not working is
'Line 4'!$K$4:$K$44703<"95")))/60
Ever time I run this, it returns 0
I am also hitting Ctrl Shift Enter not just enter.
Please help
=SUM(IF(ISNUMBER('Line 4'!$D$4:$D$44903),IF(INT('Line 4'!$D$4:$D$44903)=INT('Line 4 calc Sheet'!B3),--('Line 4'!$K$4:$K$44703<"95"))))/60

 

[FDibbins]

Take a look at using the sumifS() function for this, instead

 

[wideboydixon]

Maybe remove those quotes around "95" as well ...

 

[dreid1011]

And if it makes any difference, the ranges are not the same size:

=SUM(IF(ISNUMBER('Line 4'!$D$4:$D$44903),IF(INT('Line 4'!$D$4:$D$44903)=INT('Line 4 calc Sheet'!B3),'Line 4'!$K$4:$K$44703<"95")))/60

I know it makes a difference for some functions, maybe not here, but worth a check.

 

[wideboydixon]

Good point. I suspect the OP needs this:

{=SUM(IF(ISNUMBER('Line 4'!$D$4:$D$44903),IF(INT('Line 4'!$D$4:$D$44903)=INT('Line 4 calc Sheet'!B3),--('Line 4'!$K$4:$K$44903<95))))/60}

Did a quick test and at least it returned a non-zero result with some sample data.

WBD