Hi

I want to ADD numbers using multiple conditions.

Andy Mark MTD 10
YTD 20
CTD 30
Andy Mark MTD 40
YTD 50
CTD 60
Jhon Mark MTD 70
YTD 80
CTD 90



Now here i want to add numbers of D coloumn
If Coloumn 'A' has 'Andy' , Coloumn 'B' has 'Mark' and Coloumn 'C' has YTD
Rember A2, A3, A5, A6, B2, B3, B5 and B6 cells are blank. If I repeat Andy
and Mark in each row then its very easy to sum but i dont want to do that.

The formula should return the result (20 + 50) = 70

I want to add value for 'Andy' 'Mark' and 'YTD' and i dont want to repeat
andy and mark's name


Could you please let me know the solution.

Thanks
Milind