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