Does anyone have ideas that would SUM only the subtotal amounts in a worksheet?
N nejohnso76 Dec 8, 2006 #1 Does anyone have ideas that would SUM only the subtotal amounts in a worksheet?
D Dave Peterson Dec 8, 2006 #2 I don't. But =subtotal() that points at the whole range will ignore the =subtotal() cells and could give you what you want.
I don't. But =subtotal() that points at the whole range will ignore the =subtotal() cells and could give you what you want.
B Bernie Deitrick Dec 8, 2006 #3 IF you have SUBTOTALs applied automatically, simply use =SUM(A:A)/2 if you aren't showing the Grandtotal, and use =SUM(A:A)/3 if you are. OR, you can use =SUBTOTAL(9,A:A) which will sum everything except values in SUBTOTAL formulas... HTH, Bernie MS Excel MVP
IF you have SUBTOTALs applied automatically, simply use =SUM(A:A)/2 if you aren't showing the Grandtotal, and use =SUM(A:A)/3 if you are. OR, you can use =SUBTOTAL(9,A:A) which will sum everything except values in SUBTOTAL formulas... HTH, Bernie MS Excel MVP
L Lori Dec 8, 2006 #4 You may want to first update sum formulas to subtotal formulas by replacing "=sum(" with "=subtotal(9," in the column. Then you could use: =SUM(9,A:A)-SUBTOTAL(A:A) to sum just the subtotal formulas.
You may want to first update sum formulas to subtotal formulas by replacing "=sum(" with "=subtotal(9," in the column. Then you could use: =SUM(9,A:A)-SUBTOTAL(A:A) to sum just the subtotal formulas.
