Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
summing a volitile number of cells
I've got a row of numbers A2:K2. I want a formula that will sum from A2 to
the number of cells I enter in A1. So if I enter "3" in cell A1, the formula will sum from A2 to C2. and if I enter "5" in cell A1, it will sum from A2 to E2. I've been fiddling around in R1C1 but not getting it to work... |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
summing a volitile number of cells
Try
=SUM(OFFSET(B2,0,1,1,A2)) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Shunt" wrote in message ... I've got a row of numbers A2:K2. I want a formula that will sum from A2 to the number of cells I enter in A1. So if I enter "3" in cell A1, the formula will sum from A2 to C2. and if I enter "5" in cell A1, it will sum from A2 to E2. I've been fiddling around in R1C1 but not getting it to work... |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
summing a volitile number of cells
=SUM(OFFSET(A2,,,,A1))
Regards Trevor "Shunt" wrote in message ... I've got a row of numbers A2:K2. I want a formula that will sum from A2 to the number of cells I enter in A1. So if I enter "3" in cell A1, the formula will sum from A2 to C2. and if I enter "5" in cell A1, it will sum from A2 to E2. I've been fiddling around in R1C1 but not getting it to work... |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
summing a volitile number of cells
One way
=SUM(A2:INDEX(A2:K2,A1)) it's non volatile as opposed to OFFSET and INDIRECT Regards, Peo Sjoblom "Shunt" wrote: I've got a row of numbers A2:K2. I want a formula that will sum from A2 to the number of cells I enter in A1. So if I enter "3" in cell A1, the formula will sum from A2 to C2. and if I enter "5" in cell A1, it will sum from A2 to E2. I've been fiddling around in R1C1 but not getting it to work... |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
summing a volitile number of cells
Thanks Chip, I was cruising your web site when you for answers when you
responded in person. THX "Chip Pearson" wrote: Try =SUM(OFFSET(B2,0,1,1,A2)) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Shunt" wrote in message ... I've got a row of numbers A2:K2. I want a formula that will sum from A2 to the number of cells I enter in A1. So if I enter "3" in cell A1, the formula will sum from A2 to C2. and if I enter "5" in cell A1, it will sum from A2 to E2. I've been fiddling around in R1C1 but not getting it to work... |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
summing a volitile number of cells
A non-volatile alternative for you
=SUM(A2:INDEX(2:2,A1)) -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Shunt" wrote in message ... Thanks Chip, I was cruising your web site when you for answers when you responded in person. THX "Chip Pearson" wrote: Try =SUM(OFFSET(B2,0,1,1,A2)) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Shunt" wrote in message ... I've got a row of numbers A2:K2. I want a formula that will sum from A2 to the number of cells I enter in A1. So if I enter "3" in cell A1, the formula will sum from A2 to C2. and if I enter "5" in cell A1, it will sum from A2 to E2. I've been fiddling around in R1C1 but not getting it to work... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I want the greater number of 2 cells to show in a separate cell | Excel Discussion (Misc queries) | |||
I want the greater number of 2 cells to show in a separate cel | Excel Discussion (Misc queries) | |||
I want the greater number of 2 cells to show in a separate cell | Excel Discussion (Misc queries) | |||
Number format exactly the same, displays differently in some cells | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |