| Home |
| Search |
| Today's Posts |
|
#2
|
|||
|
|||
A formula such
=SUMPRODUCT((A1:A20)*(MOD(ROW(A1:A20),7)=0)) will reflect the changes if a row is inserted within the range. What is yours like? -- HTH RP (remove nothere from the email address if mailing direct) "Debbie" wrote in message ... I have a simple formula in excel that adds every 7th row for a total. When I add rows to this worksheet (in the center), the formula does not update to reflect the new cells. How do I get the SUM formula to update? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can a Formula in Cell X modify Cell Y? | Excel Discussion (Misc queries) | |||
| How do I fix a formula in a cell? | Excel Discussion (Misc queries) | |||
| How do I prevent incorrect formula results appearing in cell? | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
| How do I do math on a cell name in formula? | Excel Worksheet Functions | |||
Threaded Mode
