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

Hello,

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

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

Its really bugging me, any help much appreciated.

Hi

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

Andy.

"Blues" <[email protected]> wrote in
message news:[email protected]...
>
> Hello,
>
> Can anyone tell me why the following formula is returning a #VALUE!
> error?
>
> =SUM(B6*(B15:B22))+(B7*(C15:C22))+(B8*(D15:D22))
>
> Its really bugging me, any help much appreciated.
>
>
> --
> Blues
> ------------------------------------------------------------------------
> Blues's Profile:
> http://www.excelforum.com/member.php...o&userid=30771
> View this thread: http://www.excelforum.com/showthread...hreadid=525640
>

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



"Blues" wrote:

>
> Hello,
>
> Can anyone tell me why the following formula is returning a #VALUE!
> error?
>
> =SUM(B6*(B15:B22))+(B7*(C15:C22))+(B8*(D15:D22))
>
> Its really bugging me, any help much appreciated.
>
>
> --
> Blues
> ------------------------------------------------------------------------
> Blues's Profile: http://www.excelforum.com/member.php...o&userid=30771
> View this thread: http://www.excelforum.com/showthread...hreadid=525640
>
>

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

This should also work.

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

"Blues" wrote:

>
> Hello,
>
> Can anyone tell me why the following formula is returning a #VALUE!
> error?
>
> =SUM(B6*(B15:B22))+(B7*(C15:C22))+(B8*(D15:D22))
>
> Its really bugging me, any help much appreciated.
>
>
> --
> Blues
> ------------------------------------------------------------------------
> Blues's Profile: http://www.excelforum.com/member.php...o&userid=30771
> View this thread: http://www.excelforum.com/showthread...hreadid=525640
>
>