Brad,

Use a pivot table.

HTH,
Bernie
MS Excel MVP


"Brad" wrote in message
...
I have a spreadsheet that I am updating everyday with hours based on a job by
job basis and I would like summarize this into a spreadsheet for total
hours/day by installer. Here's how my detailed sheet looks. (Name of Sheet
is 'July')

Column A contains date
Column G contains Installer name
Column I contains hours

In my summary Sheet (name of sheet is 'Payroll Sumarry') I have the Date in
Column A and each installer name across the top in Row 1 so for example cell
C1 contains the name of installer I want to add. How do I do this?

I tried using the following formula =SUMPRODUCT(--(July!A:A='Payroll
Summary'!A2),--(July!G:G=C1),July!I:I) But all I get back is #NUM! error.