Hi

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

Andy.

"Blues" wrote in
message ...

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