Error

B

Blues

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
 
G

Guest

Hi

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

Andy.
 
D

Duke Carey

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
 
R

Roelof van Wyk

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

This should also work.
 
J

John Lyons

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