View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
 
Posts: 5,441
Default ArrayFunctions: How do I... ?

Brian,

Why do you want an array function? A standard SUM functions works well, as you've found, so there
is no need for an array function.

HTH,
Bernie
MS Excel MVP


"Brian Herbert Withun" wrote in message
oups.com...
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