Timesheet #VALUE! error

[Tanza]

Hi,

I am preparing one time sheet where i need to get the total time based on several condition. I applied the below formula
=IF(B7="","",SUMPRODUCT(('Daily Entry'!$D$6:$D$1003=$A$6&" - "&$A7)*('Daily Entry'!$C$6:$C$1003='Work View_Monthly'!C$4)*'Daily Entry'!$G$6:$G$1003))

I am getting #value! error

looking for your help..
Thanks in advance.
Regards
Tanza

[Special-K]

Could be a text value in the G range. Don't just look, check it properly with ISNUMBER on that range.

[arthurbr]

The opening parenthesis is also missing in the third argument

[Haseeb Avarakkan]

Since you are on Excel 2007, use SUMIFS,

=SUMIFS('Daily Entry'!$G$6:$G$1003,'Daily Entry'!$D$6:$D$1003,$A$6&" - "&$A7,'Daily Entry'!$C$6:$C$1003,'Work View_Monthly'!C$4,'Daily Entry'!$G$6:$G$1003,"<9E300")

[Tanza]

Hi all,
Thank you for helping me.
In $G$6:$G$1003 I have applied the below formula
=IF(I6>H6,IF(I6>0,IF(I6<25,I6-H6,""),""),"")
Now I removed that formula and applied data validation criteria. Problem solved!!!!

Regards,
Tanza