Is there some automatic way to make Excel total all of the cells containing
formulas in a column? I know about the Subtotals feature, and being a new
user, I can't quite figure out how to work it. I got to thinking if there is
some easy formula that SUMs the results of all formulas in the same column,
that would do exactly what I want it to do. Right now, all I'm doing to
create a grand total is creating a formula manually to give me my grand
total, i.e. =SUM(C5,C11,C18). However, if I'm going to add rows with
subtotals in between each of my categories, I'll have to manually add the
cell address of the new formula into the grand total formula. Is there a
nice, automatic way that I'm not finding, to do this, so that any new cell
with results in it is automatically added to the grand total?