#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Simplify formula

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?
  #2   Report Post  
Banned
 
Posts: 5
Default

Tôi không biết cmt đầu thì sẽ bị ai ném đá hay không , hoặc l* có cmt gì đó sai sót hay l* không , vì đa số mọi người đều nhìn cmt đầu tiên xong v* like , tôi không biết mình có được nhiều người like hay l* không , tôi cảm thấy rất l* vui nếu được like v* th*t nhiều like , cảm ơn gia đình đã sinh ra tôi , cảm ơn cha , cảm ơn mẹ đã sinh th*nh ra tôi để tôi có thể có vinh dự có mặt trên cuộc đời n*y v* trở th*nh cmt đầu tiên , v* tôi cũng xin cảm ơn b* nội đã sinh ra ba tôi , cảm ơn b* ngoại đã sinh ra mẹ tôi để tôi có thể ra đời , tôi rất mong rằng mình có một tương lai th*t sáng lạng khi trở thanh cmt đầu tiên. Quyết định trở th*nh người đầu tiên của tôi quả l* sáng suốt v* may mắn được bạn bè ủng hộ .
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Simplify formula please Iriemon Excel Worksheet Functions 5 August 14th 09 03:57 PM
simplify this formula?? Dave F Excel Discussion (Misc queries) 6 September 27th 06 05:28 PM
simplify this formula Dave F Excel Discussion (Misc queries) 2 August 23rd 06 03:06 PM
simplify this formula Dave F Excel Worksheet Functions 5 August 7th 06 10:35 PM
Simplify formula Luke Excel Worksheet Functions 37 May 6th 05 07:21 AM


All times are GMT +1. The time now is 06:21 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"