G
Guest
Is there a way to add up all the =sum() formula's in a column and ignoring
all other calculations?
Here is what I have
=b4-c4
=b5-c5
=b6-c6
_____
=sum(d2:d5)
=b8-b8
=b9-c9
_____
=sum(d6:d8)
This goes on a hundred times and I want to add all the sums without having
to enter +d7+d10+etc.. I can't use the data grouping function because it
scares the user to see it and the number of rows used will fluctuate. Is
there a way to do this?
TIA
Todd
all other calculations?
Here is what I have
=b4-c4
=b5-c5
=b6-c6
_____
=sum(d2:d5)
=b8-b8
=b9-c9
_____
=sum(d6:d8)
This goes on a hundred times and I want to add all the sums without having
to enter +d7+d10+etc.. I can't use the data grouping function because it
scares the user to see it and the number of rows used will fluctuate. Is
there a way to do this?
TIA
Todd