Two sheets, multiple inputs...

[HRSylver]

All of the excel tricks that I've been able to figure out have been self taught and I've reached a giant hurdle that I can't figure out...

I have a sheet with multiple formulas in a lot of different cells and they will be pulling information in Sheet1 from Sheet2. I have a list of positions that are associated position numbers (anywhere from 1-280) which is the point of reference between sheet1 and sheet2. Position 1 will need to search column E in sheet2 and for every cell with "1," for example rows 3 and 156, and add together the numbers in G3 and G156.

Sheet1 Sheet2 Output back in Sheet1
Column B Column E Column G
1 1 84 162
1 78

If anyone has an idea as to how to write this formula I'd be GREATLY appreciative. I hope I explained what I needed clearly enough.

 

[schielrn]

Welcome to the Board!

Maybe you need to use sumif?

=Sumif(Sheet2!E1:E280,1,G1:G280)

If not, I'm not completely understanding what you are after.

 

[HRSylver]

This worked perfectly! The last part I need is, this formula will be in Sheet1 and all the data it's referring to is in Sheet2. Where in the formula do I put that reference?

 

[schielrn]

Sorry it should have been:

=Sumif(Sheet2!E1:E280,1,Sheet2!G1:G280)

You can also change the 1 in the reference to a cell reference like:

=Sumif(Sheet2!$E$1:$E$280,A1,Sheet2!$G$1:$G$280)

Then you can copy it down and put the 1 and otehr values in column A.

 

[HRSylver]

I like that. I was thinking about that myself. Thank you so much for your help. I've been racking my brain since yesterday about this formula. You've been a great help.