SUMIFS - returns a 0 Value when referencing a cell with TIME

I know the formula works... it's returning expected results all over the place, however in the cell where it doesn't work, the value is in TIME formatting.

Do I need to conver to a number and reconvert it back where the data is supposed to be?

The value is NOT coming up as a NUMBER when validating with ISNUMBER.

Cell Value is: 89:30:32

I simply want to return the contents of that cell to another sheet.

=IF(B3='apds-jobPERF.rpt '!$C$5,SUMIF('apds-jobPERF.rpt '!B:B,'Monogram - Daily Summary'!V3,'apds-jobPERF.rpt '!E:E),"")


(FYI - I realize the post was for SUMIFS, now the formula is SUMIF - I've tried both ways to tinker with the return values).

The value is NOT coming up as a NUMBER when validating with ISNUMBER.

Cell Value is: 89:30:32

Then it is not time, it is text. Try to reference it using --
=IF(--B3='apds-jobPERF............
(not sure if B3 is teh cell, but it shows the concept)