Okoth
Board Regular
- Joined
- Sep 10, 2009
- Messages
- 106
- Office Version
- 2019
- Platform
- Windows
Hi,
I have 5 columns, 5 rows like this
<tbody>
</tbody>
I'd like to use SUM.IF to get the value from the column that is determined by the value in cell E1. The value in E1 is the result of a formula.
I'm kind of looking for a formula like this =SOM.ALS(A1:A5,A1,E1&"1":E1&"5") but of course that doesn't work.
How can I do this?
Thanks
I have 5 columns, 5 rows like this
A | B | C | D | E | |
1 | a | 1 | 11 | a | C |
2 | b | 2 | 12 | ||
3 | c | 3 | 13 | ||
4 | d | 4 | 14 | ||
5 | e | 5 | 15 |
<tbody>
</tbody>
I'd like to use SUM.IF to get the value from the column that is determined by the value in cell E1. The value in E1 is the result of a formula.
I'm kind of looking for a formula like this =SOM.ALS(A1:A5,A1,E1&"1":E1&"5") but of course that doesn't work.
How can I do this?
Thanks