Excel Workbook | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | |||
1 | Base | Base | Base | ||||||||
2 | 83 | 70 | 51 | 73 | 51 | 68 | 84 | 92 | 82 | ||
3 | 67 | 80 | 84 | 83 | 63 | 77 | 50 | 80 | 56 | ||
Sheet1 |
In the above data, A1, E1 and G1 is updated as "Base". Cell G1 is the left most column among them. Please suggest a formula to get the sum of the values in the row 2 and 3 from the left most column with text "Base". in the above case my return value will be +84+50 i.e. G2+G3 = 134..
I am not good at excel. So, please help