Index Match - summing matches ?

[SteveMc]

I'm using the following Index Match formula:

=IF(ISERROR(INDEX(datasheet,MATCH
($C4,Social,0),11)),0,INDEX(datasheet,MATCH
($C4,Social,0),11))

C4 being employee A's row & c5 is employee B's row

When the socials match, it'll indicate the workhours from
the appropriate column.

However, the below shows my problem.

On the datasheet, there may be more than one entry per
employee, e.g.

Employee A 43.18
Employee B 12.78
Employee B 18.00

The formula returns 43.18 on the main sheet for employee
A correctly, however, it only returns 12.78 for employee
B.
I need it to return 30.78 for employee B. Can this
formula we tweaked to sum all employee B's matches ?

Thanks,

 

[Aladin Akyurek]

It looks like you want to use a SumIf formula...

=SUMIF(EmployeeRange,Employee,RangeToSum)

 

[SteveMc]

Thanks,

That'll do it.

-----Original Message-----
It looks like you want to use a SumIf formula...

=SUMIF(EmployeeRange,Employee,RangeToSum)




.