Adding up based on values in other columns

[iksotof]

Good afternoon

it has been a while since i have contacted EL, change of job etc and I'm more than rusty on Excel! No less, I have a list of services say A, B an C and adjacent their prices, say £10, £20, £30. On a sheet I have users say John, Helen, Steve in a column and on the row for each drop dons for the services. So on day one John could use Service A, day 2 Service B and so on, I would like to be able to total the amount for the services John uses. I have played around with sumifs but can't seem to get it to work. Any help would be most welcome, thank you. I attach an example, so for John's row you can see services he has used in cell C4, D4 an d R4would like his services totalled up in AH4 please. the range for the data criteria and related costs are in Services tab C3:D6

Than you very much Darren.

[HansV]

Welcome back!

In AH4: =SUMPRODUCT((C4:AG4=Services!$C$4:$C$6)*Services!$D$4:$D$6)
This can be filled down.

[iksotof]

Thank you Hans

Nice to hear from you, super solution.

Regards
Darren.