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

"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