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.
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.