ExcelBanter - Error

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Error (https://www.excelbanter.com/excel-discussion-misc-queries/79136-error.html)

Blues

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.

--
Blues
------------------------------------------------------------------------
Blues's Profile: http://www.excelforum.com/member.php...o&userid=30771
View this thread: http://www.excelforum.com/showthread...hreadid=525640

Error

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

Duke Carey

Error

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

Roelof van Wyk

Error

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

This should also work.

John Lyons

Error

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

All times are GMT +1. The time now is 08:39 PM.