Hello,

I have a spreadsheet used almost like a timesheet, which I use to compare
projected hours spent against acutal hours spent. The list of names is
fairly long and can have the same name twice so I would like to create a
summary report which groups the total hours spent for an idividual person.

Example: In column 'A' I have each staff member billing their time to a
different project. Column 'B' is the expected hours they would spend over a
two day period, Column 'C' and 'D' are the actual hours spent in those two
days and Column 'E' is the total of the actual hours spent by that person on
that project.

A B C D E
1 ABC 16 8 7 15
2 DEF 16 8 8 16
3 GHI 16 8 8 16
4 ABC 16 12 9 21
5 JKL 16 8 8 16
6 MNO 16 12 8 20
7 DEF 16 8 8 16

I would like to take this data and create a summary table that looks like
this:

A B C D E
1 ABC 32 20 16 36
2 DEF 32 16 16 32
3 GHI 16 8 8 16
4 JKL 16 8 8 16
5 MNO 16 12 8 20

Which is sort of the same as above, however, all of the time spent by 'ABC'
is now consolidated into one row. My list is very long and I do not want to
use filters or program in miles of "IF" statements so I was wondering if
there was a certain type of "SUMIF" formula that would work. Please let me
know. THANKS!