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

Take a look at the SumIf() function.
HTH,

--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"JuanPabloGallardo" wrote:

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