| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Resize Sumif formula parameters for added data
2007 (compatibility mode 2003)
Two sections of w/s Top contains Sumif formulas Bottom contains detail data which is Sumif'd in the top section Data has been added to the bottom section. All of the Sumif formulas contain (except for the Relative "A2"): =SUMIF($A$68:$A$350,A2,$D$68:$D$350) The new data range extends to 386 Therefore, the formula needs to be =SUMIF($A$68:$A$386,A2,$D$68:$D$386) I could use a Replace but I do not think that it is the smartest approach. Plus I would have to calculate the number to replace. I have a variable in the code area for the Row of the last data item. Thoughts? TIA EagleOne |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Leaving a formula cell blank when data has not yet been added. | Excel Discussion (Misc queries) | |||
| Formula needed: argument changes as more data is added | Excel Worksheet Functions | |||
| Array in formula Vlookup changes when data list is added to | Excel Worksheet Functions | |||
| Parameters of SUMIF in VBA | Excel Programming | |||
| When I click buttons I have added the font or button resize, Why? | Excel Discussion (Misc queries) | |||
Threaded Mode
