Sum

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scrabble Value calculation for Welsh words 0
add hyperlink using sheet names and cells(i,j) 3
How to I sum different data from different sheets 3
count a value in a date range based on a date in another workshee. 4
lookup second / last match with two conditions 1
OFFSET with a condition 0
Index with mulitple value returns and muliple column returns 4
Regression Leverage Formula (Jerry W. Lewis or Mike Middleton)already have DFITS formula 2

Back
Top