# Multiple Sum If A Cell Value Equal Another Cell

Nov 17, 2006I'm doing a spreadsheet where there is ten cells or top ten positions. Where there is one sheet for where the ten values and another sheet with cells that might or might not match the other sheet. For instance.

If any cell A1 on sheet 1 matches cell A1 on sheet 2 Then give cell A15 the value of 10. The If cell A2 on sheet 1 matches A2 on sheet 2 Then add another 10 giving A15 a total of 20. And so on up To A10. Then If it doesn 't match exactly lets say If cell A4 on sheet 1 match cell A2 the Minis 4 from 2 giving you 2 Then minis 2 from 10 giving 8 While still totaling In cell A15, which would equal 18 now.