Home |
Search |
Today's Posts |
#1
|
|||
|
|||
"if" formula to sum several cells...
Hi all,
I need to sum some consecutive cells in a row, depending on a number in another cell. For instance: If the cell contains 2 sum A1 + B1 If the cell contains 3 sum A1 + B1 + C1 If the cell contains 4 sum A1 + B1 + C1 + D1 and so on ... is there a function to do that or vba code needs to be written? any help will be very much appreciated. Thanks! Massimo |
#2
|
|||
|
|||
Suppose the cell that is supposed to conain 2 or 3 or 4 is A3, then use
formula: =SUM(A1:OFFSET(A1,0,A3-1)) Mangesh "Massimo" wrote in message ... Hi all, I need to sum some consecutive cells in a row, depending on a number in another cell. For instance: If the cell contains 2 sum A1 + B1 If the cell contains 3 sum A1 + B1 + C1 If the cell contains 4 sum A1 + B1 + C1 + D1 and so on ... is there a function to do that or vba code needs to be written? any help will be very much appreciated. Thanks! Massimo |
#3
|
|||
|
|||
With the cell of reference being C1, try this:
=SUM(A1:INDEX(A:A,C1)) -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Massimo" wrote in message ... Hi all, I need to sum some consecutive cells in a row, depending on a number in another cell. For instance: If the cell contains 2 sum A1 + B1 If the cell contains 3 sum A1 + B1 + C1 If the cell contains 4 sum A1 + B1 + C1 + D1 and so on ... is there a function to do that or vba code needs to be written? any help will be very much appreciated. Thanks! Massimo |
#4
|
|||
|
|||
Thanks Mangesh,
your formula works perfectly. :)) Massimo "Mangesh Yadav" wrote: Suppose the cell that is supposed to conain 2 or 3 or 4 is A3, then use formula: =SUM(A1:OFFSET(A1,0,A3-1)) Mangesh "Massimo" wrote in message ... Hi all, I need to sum some consecutive cells in a row, depending on a number in another cell. For instance: If the cell contains 2 sum A1 + B1 If the cell contains 3 sum A1 + B1 + C1 If the cell contains 4 sum A1 + B1 + C1 + D1 and so on ... is there a function to do that or vba code needs to be written? any help will be very much appreciated. Thanks! Massimo |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
see the cells the formula relates to by double clicking the cell | Excel Discussion (Misc queries) | |||
trying to create an (almost) circular formula between cells and data validated cells with lists | Excel Worksheet Functions | |||
Macro or Formula to remove Text from Cells | Excel Worksheet Functions | |||
Need a 1 Column multiplication formula for 2600 cells. How? | Excel Worksheet Functions | |||
How do i select different cells to be use in a formula. | Excel Discussion (Misc queries) |