Don't think it's possible via formulas
This approach might work:
1. Use a sub by Ron to merge data from all source sheets
2. Create a pivot table to get the unique listing and corresponding sums
For (1), go to Ron's page at:
http://www.rondebruin.nl/copy2.htm
Look for: Copy from row 2 till the last row with data
Copy n paste into a module
a. Sub Test2()
b. Function LastRow(sh As Worksheet)
Before running the sub, group all source sheets and insert a top row for col
labels and put in the labels. Run the Sub Test2().
Then in the MergeSheet, insert a top row, put in the 3 col labels. Create a
pivot on the data in the merged sheet, drop col A label in ROW area, cols B &
C labels in the DATA area (SUM). Then go to the pivot sheet, drag DATA and
drop over "Total", and you'd get the desired results.

Signature
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
> Looking through multiple worksheets:
>
[quoted text clipped - 54 lines]
> 4 Ralph 12 12
> 5 Bear 6 5