Error

[Blues]

Hello,

Can anyone tell me why the following formula is returning a #VALUE
error?

=SUM(B6*(B15:B22))+(B7*(C15:C22))+(B8*(D1522))

Its really bugging me, any help much appreciated

 

[Guest]

Hi

This is an array formula and should be entered with Ctrl+Shift+Enter to
work.

Andy.

 

[Guest]

It's an array formula. Are you commiting it as an array?

Do so by selecting the cell with the formula, pressing the F2 key to go into
edit mode, then pressing

Shift-Ctrl-Enter

 

[Roelof van Wyk]

=(B6*(SUM((B15:B22)))+(B7*(SUM(C15:C22)))+(B8*(SUM(D1522))))

This should also work.

 

[Guest]

I don'y think SUM likes the multiplication within the brackets!
Try
=(B6*SUM(B15:B22))+(B7*SUM(C15:C22))+(B8*SUM(D1522))