B
Brian Herbert Withun
I want to know how to write a particular array function in Excel 2000.
Given: A table whose columns are days (S,M,T,W,T,F,S) and rows are
weeks (11/4,11/11,11/18) and whose cells are pagehits (integers)
I want to create a new column, WeeklyTotal, and I want that column
(column I) to be calculated using an arrayfunction.
Using a regular formula I can write I2 =SUM(B2:H2),
and I3 =SUM(B3:H3),
and I4 =SUM(B4:H4),
and ...
Using an array formula, what could I write? Assume I have data in
rows 2:10,
This doesn't work: I2:I10 {=SUM(B2:H2:B10:H10)} It gives a result,
but the wrong one.
This DOES work, but I hope there is an easier way:
I2:I10 {=B2:B10+C2:C10+D210+E2:E10+F2:F10+G2:G10+H2:H10}
So my question; *is* there an easier way, a shorter formula?
Brian Herbert Withun
Given: A table whose columns are days (S,M,T,W,T,F,S) and rows are
weeks (11/4,11/11,11/18) and whose cells are pagehits (integers)
I want to create a new column, WeeklyTotal, and I want that column
(column I) to be calculated using an arrayfunction.
Using a regular formula I can write I2 =SUM(B2:H2),
and I3 =SUM(B3:H3),
and I4 =SUM(B4:H4),
and ...
Using an array formula, what could I write? Assume I have data in
rows 2:10,
This doesn't work: I2:I10 {=SUM(B2:H2:B10:H10)} It gives a result,
but the wrong one.
This DOES work, but I hope there is an easier way:
I2:I10 {=B2:B10+C2:C10+D210+E2:E10+F2:F10+G2:G10+H2:H10}
So my question; *is* there an easier way, a shorter formula?
Brian Herbert Withun