subtotals

  • Thread starter Thread starter ibeetb
  • Start date Start date
I

ibeetb

I want to create a subtotal at every seven cells in a column. I cannot use
the subtotal function because I have all unique values in each row....I
would prefer not to create a new column with a value in each seventh row to
use the subtotal function with. Any ideas?
 
Put this formula in B7, and then copy down to all rows

=IF(MOD(ROW(),7)=0,SUM(A1:A7),"")
 
With your data in say A1:A1000, in cell B1 put the following and copy down to B1000

=IF(MOD(ROW(),6)=1,1,"")

Delete the first 1 which will appear in the first row.

Select the entire column B and do edit / Go To / Special / Formulas (Uncheck all except Numbers)

Do Edit / Insert / Rows and then delete Col B

Select Col A and do edit / Go To / Special / Blanks

Type =SUM(A1:A6) and hit CTRL+ENTER at the same time. Now hit CTRL+B at the same time.
 
Back
Top