# Two sheets, multiple inputs...

#### HRSylver

##### Board Regular
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.

### Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

#### schielrn

##### Well-known Member
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

##### Board Regular
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

##### Well-known Member
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

##### Board Regular
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.

Replies
10
Views
713
Replies
0
Views
1K
Replies
24
Views
1K
Replies
6
Views
496
Replies
7
Views
316

1,191,073
Messages
5,984,473
Members
439,891
Latest member
maikii

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back