Index Match - summing matches ?

  • Thread starter Thread starter SteveMc
  • Start date Start date
S

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,
 
It looks like you want to use a SumIf formula...

=SUMIF(EmployeeRange,Employee,RangeToSum)
 
Back
Top