Sumproduct.

[taylo40]

Hello,
I have a query and I think that sumproduct is the answer but I can't quite resolve the query.

I have an Excel Spreadsheet that is used for time recording.

Column A = Week Number - eg 17, 18 etc
Column B = Employee Name.
Column C - Number of Hours for the day.

I have created a summary sheet to highlight how many hours the employee is working per week.

When I use the sumproduct formula = it adds the number of occurances rather than adding the number of hours for that week.

Any advice ?

Regards,

Jamie

 

[xlbo]

you need a non tested range at the end to sum eg

=SUMPRODUCT((Range1=test1)*(Range2=test2)*(SumRange))

where SumRange would be the hours worked

Rgds, Geoff

Three things are certain. Death, taxes and lost data. DPlank is to blame

Please read FAQ222-2244 before you ask a question