| 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 |
| 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) | |||
Threaded Mode
