KK1966
01-21-2010, 11:45 PM
Can anyone help me why does can’t round with sumproduct formulas as the value in col G is 00:00:00.
What’s I want to get if the return value = 12:14:54
Can range A1 be come = 12:15 as range A1 format 00:00, but it is resulted 12:14
I try formulas below but it not work
=SUMPRODUCT(ROUND(G3:G500(($A$3:$A$500="Fcode")*($B$3:$B$500="Ftc")*(MOD($F$3:$F$500,1)<"15:00:00"+0),$G$3:G$500),3))
Thanks
What’s I want to get if the return value = 12:14:54
Can range A1 be come = 12:15 as range A1 format 00:00, but it is resulted 12:14
I try formulas below but it not work
=SUMPRODUCT(ROUND(G3:G500(($A$3:$A$500="Fcode")*($B$3:$B$500="Ftc")*(MOD($F$3:$F$500,1)<"15:00:00"+0),$G$3:G$500),3))
Thanks