On Wednesday, July 24, 2002 at 8:51:00 AM UTC-7, Harlan Grove wrote:
Glenn Schwandt wrote...
Thanks, but I don't think this would work for me. I need to be able to
copy
this formula across. See my reply to Niek Otten for more details.

"Dave Patton" wrote in message
You could put cumulative amount in say row 8
=SUM($B$7:B7) and copy across

and use a formula like
=7-COUNTIF(B8:H8,""&B3)
...
"Glenn Schwandt" wrote in message
Any array formulas or other options to replace this?

=(B3B7)+(B3SUM(B7:C7))+(B3SUM(B7:D7))+(B3SU M(B7:E7))
+(B3SUM(B7:F7))+(B3SUM(B7:G7))+(B3SUM(B7:H7) )
...

Meaning you have this beast in, say, X3 and you want to copy it into Y3 and
get

=(C3C7)+(C3SUM(C7:D7))+(C3SUM(C7:E7))+(C3SUM(C 7:F7))
+(C3SUM(C7:G7))+(C3SUM(C7:H7))+(C3SUM(C7:I7))

?

If so, try this array formula in X3.

=SUM((B3MMULT(B7:H7,(COLUMN(B7:H7)
=TRANSPOSE(COLUMN(B7:H7)))+0))+0)

Do you have a solution for if the spreadsheet was transposed, with weeks in one column as well as the other metrics? I figured it'd be as easy as switching the references, and using "ROW" function instead of column, but my formula is returning a #VALUE error. Any help?