Sum consecutive columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a worksheet where I sum columns 1:9 into column 19 and sum columns 10:18 into column 20. When I enter the numbers in columns 1:18, Excel seems to change the formula in column 19 from =SUM(a1:a9) to =SUM(a1:a18)

Thanks in advance for any advice.
 
It looks like you want the formula in cell A19, try...

either:

=AVERAGE(OFFSET(Day!A$1,(ROW()-ROW($A$19))*9,0,9,1))

or:

=AVERAGE(OFFSET(A$1,(ROWS($1:1)-1)*9,0,9,1))

Lamar Hinton said:
I have a worksheet where I sum columns 1:9 into column 19 and sum columns
Click to expand...
10:18 into column 20. When I enter the numbers in columns 1:18, Excel seems
to change the formula in column 19 from =SUM(a1:a9) to =SUM(a1:a18).
 
Lamar

You have columns and rows(cells) mixed up. Columns run from top to bottom and
rows run across the sheet.

1,2,3,4,5 etc. are row numbers down the left side.

A,B,C,D,E etc. are column letters across the top.

Looks like your numbers are in Column A from A1 to A18.

In A19 enter =SUM(A1:A9)

In A20 enter =SUM(A10:A18)

Gord Dibben Excel MVP
 
This is one of Redmond's renowned *features*!

<Tools> Options> <Edit> tab,
And *uncheck* "Extend List Formats And Formulas".
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I have a worksheet where I sum columns 1:9 into column 19 and sum columns
10:18 into column 20. When I enter the numbers in columns 1:18, Excel seems
to change the formula in column 19 from =SUM(a1:a9) to =SUM(a1:a18).

Thanks in advance for any advice.
 
Back
Top