Summing data from a table with multiple entries

[JLitchford]

Hi -

Looking for help with a formula -

I have two staff members who are assigned to work on tasks for several milestones.

I want to be able to add up all of the dates for each person for each milestone.

I've attached a sample and would appreciate any suggestions.

Jeff
(excel 2003)

[Palmetto]

In cell B14 copied across and then down

=SUMPRODUCT(--($A$2:$A$8=RIGHT(B$13,1)+0)*--($C$2:$C$8=$A14)*($B$2:$B$8))

Or, you could use a Pivot Table.