Hi friends,
In excel 2003 i m using below sumproduct formula for calculate duration and its work. But i want to using sumif instead of sumproduct.
=TEXT(INT(SUMPRODUCT((FSR_NGP!AE$2:AE$65001=$A5)*( FSR_NGP!S$2:S$65001=$E$4),FSR_NGP!U$2:U$65001)), "00 ")&TEXT(SUMPRODUCT((FSR_NGP!AE$2:AE$65001=$A5)*(FS R_NGP!S$2:S$65001=$E$4),FSR_NGP!U$2:U$65001),"hh :mm")

AE & A5 = employee code
S & E4 = month & year
U = duration (format with dd hh:mm)
Above formula calculat perfectly but with sumproduct is work slow & i want to used sumif formula.

In FSR_NGP sheet in column AH i have join month,year & employee code.
But i have facing problem when replacing sumif function.