| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Error
=(B6*(SUM((B15:B22)))+(B7*(SUM(C15:C22)))+(B8*(SUM (D15:D22))))
This should also work. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Ignore error msgs in formula references | Excel Discussion (Misc queries) | |||
| Error trapped only while stepping through the code - Not triggered when run | Excel Discussion (Misc queries) | |||
| Error trapped only while stepping through the code - Not triggered when run | Excel Discussion (Misc queries) | |||
| Problem with VBA returning the contents of a long formula. | Excel Discussion (Misc queries) | |||
| ERROR | Excel Discussion (Misc queries) | |||
Linear Mode
