Issue with SUMPRODUCT -- Request for Assistance

[praveenkagitala]

Hi Friends,

I am trying to create a sheet which captures the Worked hrs for users in various cells. The SUMPRODUCT does not seem to be working for me and would seek your help in getting this fixed.

Attached is the sample sheet which i would like to get the SUM using SUMPRODUCT.

Col D under Data Sheet has the names and these are repetitive. The Hrs / min in column E & F (Regular Hrs) & Additional Hrs / min under H & I.

I would like to have the Regular hrs + minutes to SUM up against each individual and displayed in consolidated under Col D (Regular hrs) & Col E (Additional Hrs).

I am using Excel 2010 and when i have used the same formulae in 2003 it worked. Not sure why it is not working in 2010.

Please help me !!!!

[MarvinP]

Hi Praveen,

See if this is what you need.

[praveenkagitala]

Hi Marvin,

Your sheet works perfectly fine, but when I apply the same formulae in my sheet, it worked fine for Reported Hours. But for Extra Efforts Reported it throws me an #N/A error. Attached is the file on which I am working on but not successful in calculating.

Please Marvin, help me on this. Also, let me know when we use SUMPRODUCT in the formulae bar do we just press ENTER or SHIFT + ENTER.

Thanks in Advance

Regards,
Praveen