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 :) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
AutoSum for variable number of cells
I think I would get rid of those blank lines.
Then (with the data sorted by that column), use xl's built in Data|Subtotals to get those values. If you add extra rows of data, remove the subtotals, resort the data and reapply the data|subtotals. You may want to look at Data|pivottable, too. MMH wrote: 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 :) -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
AutoSum for variable number of cells
That is absolutely fantastic. I never knew that function was there.
Thank you very much. MMH :) "Dave Peterson" wrote: I think I would get rid of those blank lines. Then (with the data sorted by that column), use xl's built in Data|Subtotals to get those values. If you add extra rows of data, remove the subtotals, resort the data and reapply the data|subtotals. You may want to look at Data|pivottable, too. |
Reply |
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 |