- Joined
- Aug 31, 2018
- Messages
- 2
- Reaction score
- 1
Hi,
I am trying to use some of the more complex formulas, to make things easier on myself.
I have a workbook, with 4 sheets. The first 3 are data, and the 4th is a merging of the first 3. The teams will be making changes to Columns H, I, & J on the first 3 sheets. Right now, all 4 sheets have identical information.
So far, on sheet 4, I have added 2 additional columns for each corresponding column on the first 3. Column G collects from Sheet 1 G2, Column H from Sheet 2, G2 and Column I, G2 from Sheet 3. Same with J, K, L (from H2) Same with N,O,P (collecting from I2)
The ONLY reason it is like this, is in case the same exact item is counted in a second place. (I need to see if that happens.)
So - here is the question: I would like Sheet 4 Column M to tell me how many marks are in G2:L2, but because there are formulas in those cells, it counts the formulas. What do I do instead?
If you have ideas for making this easier, I'm all for ideas!
Thank you!
I am trying to use some of the more complex formulas, to make things easier on myself.
I have a workbook, with 4 sheets. The first 3 are data, and the 4th is a merging of the first 3. The teams will be making changes to Columns H, I, & J on the first 3 sheets. Right now, all 4 sheets have identical information.
So far, on sheet 4, I have added 2 additional columns for each corresponding column on the first 3. Column G collects from Sheet 1 G2, Column H from Sheet 2, G2 and Column I, G2 from Sheet 3. Same with J, K, L (from H2) Same with N,O,P (collecting from I2)
The ONLY reason it is like this, is in case the same exact item is counted in a second place. (I need to see if that happens.)
So - here is the question: I would like Sheet 4 Column M to tell me how many marks are in G2:L2, but because there are formulas in those cells, it counts the formulas. What do I do instead?
If you have ideas for making this easier, I'm all for ideas!
Thank you!
