Home |
Search |
Today's Posts |
#1
|
|||
|
|||
formula to sum all sum calculations in a column
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 |
#2
|
|||
|
|||
Hi
depends if you somehow can identify these vells. e.g. do they have a label in another column or are they always at specific cell positions -- Regards Frank Kabel Frankfurt, Germany "Todd" schrieb im Newsbeitrag ... 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 |
#3
|
|||
|
|||
Hi Todd
if you do a search & replace to replace =SUM( with =SUBTOTAL(9, you can then use =subtotal(9,the_full_range) function at the bottom to add up all the ranges excluding the other subtotals alternatively, you could just sum the whole lot & divide by 2 ??? Cheers JulieD "Todd" wrote in message ... 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 |
#4
|
|||
|
|||
Thanks! ( both of you) I used the subtotal function.
"Frank Kabel" wrote: Hi depends if you somehow can identify these vells. e.g. do they have a label in another column or are they always at specific cell positions -- Regards Frank Kabel Frankfurt, Germany "Todd" schrieb im Newsbeitrag ... 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 |
#5
|
|||
|
|||
you're welcome and thanks for the feedback
"Todd" wrote in message ... Thanks! ( both of you) I used the subtotal function. "Frank Kabel" wrote: Hi depends if you somehow can identify these vells. e.g. do they have a label in another column or are they always at specific cell positions -- Regards Frank Kabel Frankfurt, Germany "Todd" schrieb im Newsbeitrag ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert rows based on specific value | Excel Worksheet Functions | |||
what formula do i put for column m = column k minus column l in e. | Excel Discussion (Misc queries) | |||
formula to determine the first column containing any data | Excel Worksheet Functions | |||
Can you enter a formula in a cell that auto-inputs calculations a. | Excel Worksheet Functions | |||
Adding TR to the end of each value in a column..formula | Excel Worksheet Functions |