ExcelBanter - sum (column 2 of namedrange)

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - sum (column 2 of namedrange) (https://www.excelbanter.com/excel-programming/274946-re-sum-column-2-namedrange.html)

sum (column 2 of namedrange)

Leo Heuser wrote:
Carl
2.
First column:
=SUM(OFFSET(E1:F6,0;0,,1)) :::or =SUM(INDEX(E1:F6,0,1)
Second column:
=SUM(OFFSET(E1:F6,0;1,,1)) :::or =SUM(INDEX(E1:F6,0,2)
etc.

First row:
=SUM(OFFSET(E1:F6,0;0,1,)) :::or =SUM(INDEX(E1:F6,1,0)
Second row:
=SUM(OFFSET(E1:F6,1;0,1,)) :::or =SUM(INDEX(E1:F6,2,0)
etc.

And the semicolon in Leo Heuser's formulas is a typo.

Alan Beban

sum (column 2 of namedrange)

Thanks, Alan!

To Carl:
And the missing righthand parenthesis in Alan's
formulae is a typo <g

LeoH

"Alan Beban" skrev i en meddelelse
...
Leo Heuser wrote:
Carl
2.
First column:
=SUM(OFFSET(E1:F6,0;0,,1)) :::or =SUM(INDEX(E1:F6,0,1)
Second column:
=SUM(OFFSET(E1:F6,0;1,,1)) :::or =SUM(INDEX(E1:F6,0,2)
etc.

First row:
=SUM(OFFSET(E1:F6,0;0,1,)) :::or =SUM(INDEX(E1:F6,1,0)
Second row:
=SUM(OFFSET(E1:F6,1;0,1,)) :::or =SUM(INDEX(E1:F6,2,0)
etc.

And the semicolon in Leo Heuser's formulas is a typo.

Alan Beban

sum (column 2 of namedrange)

Okay now why use index instead of offset. What are the advantages and
disadvantages of each way? Is there times when one is better than the other?

--
Carl & Linda Brehm
Lake Lafourche Bird House
Hebert, LA
Keets, Tiels, GN & Red Lories, Quakers
Mitred Conures, TAG's,DYH, Bourkes,
Cages, Toys, Toy parts Wholesale/Retail
Feed & Supplies
"Leo Heuser" wrote in message
...
Thanks, Alan!

To Carl:
And the missing righthand parenthesis in Alan's
formulae is a typo <g

LeoH

"Alan Beban" skrev i en meddelelse
...
Leo Heuser wrote:
Carl
2.
First column:
=SUM(OFFSET(E1:F6,0;0,,1)) :::or =SUM(INDEX(E1:F6,0,1)
Second column:
=SUM(OFFSET(E1:F6,0;1,,1)) :::or =SUM(INDEX(E1:F6,0,2)
etc.

First row:
=SUM(OFFSET(E1:F6,0;0,1,)) :::or =SUM(INDEX(E1:F6,1,0)
Second row:
=SUM(OFFSET(E1:F6,1;0,1,)) :::or =SUM(INDEX(E1:F6,2,0)
etc.

And the semicolon in Leo Heuser's formulas is a typo.

Alan Beban

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.504 / Virus Database: 302 - Release Date: 07/24/2003