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