Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
AutoSum for variable number of cells
I have a worksheet with $ values for different people. The data is sorted by
the name of the person, and I have inserted a blank line between each person's values. Now I want to calculate the total value of the items for each person in the blank line (e.g. XXX has values in F2:F11, YYY has values in F13:F28). I tried using the AutoSum feature, but I cannot work out how to modify the code so it will work with a variable number of populated cells. I could really use a hand here. Thank you in advance for your help. MMH :) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum over a variable number of cells | Excel Discussion (Misc queries) | |||
Summing a Variable Number of Cells | Excel Discussion (Misc queries) | |||
Autosum variable range in macro | Excel Programming | |||
Autosum variable range in macro | Excel Programming | |||
Autosum variable range in macro | Excel Programming |