JenniferMurphy
Well-known Member
- Joined
- Jul 23, 2011
- Messages
- 2,532
- Office Version
- 365
- Platform
- Windows
In the table below, the following named ranges are defined:
<tbody>
</tbody>
I need a formula in E1 that will be the equivalent of =sum(B1:D1) but using the named ranges.
<tbody>
</tbody>
I've tried as many combinations of row(), column(), address(), cell(), etc., as I can think of, but mostly I get errors.
I know I can accomplish this sum by naming B1:D1 something like "JanRow" and then using "=sum(JanRow)", but I like having the column named refer to the columns just to the left and right of the table so that they move if I add columns. But regardless of alternative solutions, I'd like to know how to do this.
$A:$A | TableLeft |
$E:$E | TableRight |
$1:$1 | Jan |
$2:$2 | Feb |
$3:$3 | Mar |
<tbody>
</tbody>
I need a formula in E1 that will be the equivalent of =sum(B1:D1) but using the named ranges.
R/C | A | B | C | D | E |
1 | Jan | 3 | 7 | 4 | 14 |
2 | Feb | 6 | 5 | 6 | 17 |
3 | Mar | 4 | 1 | 3 | 8 |
<tbody>
</tbody>
I've tried as many combinations of row(), column(), address(), cell(), etc., as I can think of, but mostly I get errors.
I know I can accomplish this sum by naming B1:D1 something like "JanRow" and then using "=sum(JanRow)", but I like having the column named refer to the columns just to the left and right of the table so that they move if I add columns. But regardless of alternative solutions, I'd like to know how to do this.