| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Resize Sumif formula parameters for added data
Roger, I like your idea - use of Index().
Index is an XL function. What is the comparable VBA function? "Roger Govier" wrote: Hi you could set up some dynamic ranges. You say you have a variable which gives the last row number. Lets say this is held in cell A1 InsertNameDefine Name rngA Refers to =$A$68:INDEX($A:$A,$A$1) Name rngD Refers to =$D$68:INDEX($D:$D,$A$1) then =SUMIF(rngA,A2,rngD) |
| 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
