Index, Match and return sum of the matched values

[Nicostin]

Hi there - I am hoping someone can help me with my first post on any forum.

I have a set of data where there are duplicate occurrences of the same person. Each duplicate person has other attributes which make the data unique which is used in another report and I used 'Index, Match' to return values.

My query is that I need to add up the total (hours worked) for all the duplicate matches of the person in another report? Pivots are not an option.

Guessing its possible, but what approach do I need to take?

Any help appreciated. Thanks

 

[Special-K99]

Post a (dummy) spreadsheet.

 

[RonB1111]

Probably SUMIF() function.
See: Using SUMIF to add up cells in Excel that meet certain criteria. Learn | Five Minute Lessons

If you need help formulating it, please post a small sample of your data and the expected results.

 

[Nicostin]

Datta to be returned is the hours
		Weekending
Names and Rates	Type	10-Jul	17-Jul	24-Jul	31-Jul	07-Aug
Jon	Hours
130	Blended Price Rate	0	0	0	0	0
100	Cost Rate	0	0	0	0	0
Pete	Hours
130	Blended Price Rate	0	0	0	0	0
100	Cost Rate	0	0	0	0	0
Ian	Hours
130	Blended Price Rate	0	0	0	0	0
100	Cost Rate	0	0	0	0	0
Source Data
Projects	Name	10-Jul	17-Jul	24-Jul	31-Jul	07-Aug
Project 1	Jon	20	20	20	20	20
Project 2	Jon	10	10	10	10	10
Project 3	Jon	10	10	10	10	10
Project 1	Pete	20	20	20	20	20
Project 2	Pete	20	20	20	20	20
Project 2	Ian	40	40	40	40	40

<tbody>
</tbody>

the week's are variable, so don't think SUMIFs really work in this one.

 

[RonB1111]

Enter formula in C2, copy across to G2 (or as far across as you expect to have w/e dates, then copy to C5:G5, then copy to C7:G7:

=SUMIF($B$15:$B20,$A2,C$15:C$20)

If the date columns between the top and bottom table don't line up, let me know how they're actually structured so I can adjust the formula to accomodate.