Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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+D2:D10+E2:E10+F2:F10+G2:G10+H2:H10 } So my question; *is* there an easier way, a shorter formula? Brian Herbert Withun |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Has anyone used arrayfunctions from Alan Beban? | Excel Worksheet Functions |