ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   range name (https://www.excelbanter.com/excel-worksheet-functions/6034-range-name.html)

Pedro

range name
 
Hi everyone
Suppose this example:
a1;a2;A3 equals 5, 7, 9
b1;b2;b3 equals 2, 3,8
Name range for first range abc
Name range for second range def
There's a formula on cell c1 : Sum(abc)
What i would like is : on cell d1, i input abc or def or another range name
and on cell c1, without any macro but a formula, it sums what i input on cell
d1, abc or def.
Can you help me please?
Tks in advance
Pedro


All times are GMT +1. The time now is 02:38 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com