Hi,
I have several sheets, with repeated cell names and values asigend to each
name:
ie.
Sheet1 A1=x ; B1=y
Sheet2 A8=x ; B8=y+1
Shhet3 A13=x ; B13=y+2

How can I create a formula in Sheet 4, that looks up all 'x' values on
Sheet1, 2 and 3 and if true, then add the numbers y+y+1+y+2?

Thanks

Juan Pablo Gallardo