Can anyone suggest a simpler Formula? Thanks!

[Satya]

Please look at below long formula. Note that Cell1, Cell2, etc. are different worksheets.

I tried replacing this formula by using
SUMPRODUCT(B1:B40, Cell1:Cell40!F44), or even
SUM(B1:B40 * Cell1:Cell40!F44)

But the formulas don't work, and give me back a REF! error. It seems to be because I am trying to select the second array across multiple worksheets.

ANY HELP IS HIGHLY APPRECIATED!

Formula to be replaced is...

=$B$1*Cell1!F44+$B$2*Cell2!F44+$B$3*Cell3!F44+$B$4*Cell4!F44+$B$5*Cell5!F44+$B$6*Cell6!F44+$B$7*Cell7!F44+$B$8*Cell8!F44+$B$9*Cell9!F44+$B$10*Cell10!F44+$B$11*Cell11!F44+$B$12*Cell12!F44+$B$13*Cell13!F44+$B$14*Cell14!F44+$B$15*Cell15!F44+$B$16*Cell16!F44+$B$17*Cell17!F44+$B$18*Cell18!F44+$B$19*Cell19!F44+$B$20*Cell20!F44+$B$21*Cell21!F44+$B$22*Cell22!F44+$B$23*Cell23!F44+$B$24*Cell24!F44+$B$25*Cell25!F44+$B$26*Cell26!F44+$B$27*Cell27!F44+$B$28*Cell28!F44+$B$29*Cell29!F44+$B$30*Cell30!F44+$B$31*Cell31!F44+$B$32*Cell32!F44+$B$33*Cell33!F44+$B$34*Cell34!F44+$B$35*Cell35!F44+$B$36*Cell36!F44+$B$37*Cell37!F44+$B$38*Cell38!F44+$B$39*Cell39!F44+$B$40*Cell40!F44

 

[NateO]

No I am not!

That's two misreads in one post!

I apologize to all! Thank God it's Friday!!

 

[Mat]

I apologize to all!

We forgive you!

Thank God it's Friday!!

You're Welcome! :D

 

[Satya]

Hi All,

Many thanks for all the suggestions. I've just checked these replies from home. I will try out suggested solutions in my office, and get back with what worked and what didn't!

Thanks again!

Satya