jumbledore
Active Member
- Joined
- Jan 17, 2014
- Messages
- 262
I have the following table starting from cell A1 to D6:
<tbody>
</tbody>
In cell A9 if I were to enter a value say "stu" it should give me the sum of the 2 rows above. For example if I enter the formula in B9 it should return, 96+8=104. For "ghi", 53+76=129
How do I do so?
Thanks
1 | 34 | 53 | 8 |
2 | 45 | 76 | 9 |
abc | def | ghi | jkl |
23 | 55 | 96 | 4 |
3 | 51 | 8 | 38 |
mno | pqr | stu | vwx |
<tbody>
</tbody>
In cell A9 if I were to enter a value say "stu" it should give me the sum of the 2 rows above. For example if I enter the formula in B9 it should return, 96+8=104. For "ghi", 53+76=129
How do I do so?
Thanks
Last edited: