Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula assistance
I want to take A1:A10 and multiply by .585
then... A:11:A20 multiplied by .55 = total result on A25 I went something like this....and it won't work: =sum(a1:a5)*.585+(a11:a20)*.55 All I get is #VALUE and the help prompts do not help. I am using Excel 2007 Any help appreciated |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula assistance
Hi,
Try this =(sum(a1:a5)*.585)+(sum(a11:a20)*.55) -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "TSA" wrote in message ... I want to take A1:A10 and multiply by .585 then... A:11:A20 multiplied by .55 = total result on A25 I went something like this....and it won't work: =sum(a1:a5)*.585+(a11:a20)*.55 All I get is #VALUE and the help prompts do not help. I am using Excel 2007 Any help appreciated |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula assistance
Try this array formula
=SUM(A1:A5*0.585,A11:A20*0.55) as an array formula commit with Ctrl-Shift-Enter -- __________________________________ HTH Bob "TSA" wrote in message ... I want to take A1:A10 and multiply by .585 then... A:11:A20 multiplied by .55 = total result on A25 I went something like this....and it won't work: =sum(a1:a5)*.585+(a11:a20)*.55 All I get is #VALUE and the help prompts do not help. I am using Excel 2007 Any help appreciated |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula assistance
But you can scrub the outer parentheses.
=(sum(a1:a5)*.585)+(sum(a11:a20)*.55) can be simplified to =sum(a1:a5)*.585+sum(a11:a20)*.55 And if the text of the original question was correct, change the A5 reference to A10. And to the OP, please don't multipost. Your question was answered in your earlier thread. -- David Biddulph "Ashish Mathur" wrote in message ... Hi, Try this =(sum(a1:a5)*.585)+(sum(a11:a20)*.55) -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "TSA" wrote in message ... I want to take A1:A10 and multiply by .585 then... A:11:A20 multiplied by .55 = total result on A25 I went something like this....and it won't work: =sum(a1:a5)*.585+(a11:a20)*.55 All I get is #VALUE and the help prompts do not help. I am using Excel 2007 Any help appreciated |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula assistance
slight correction
=SUM(A1:A10*0.585,A11:A20*0.55) still array entered -- __________________________________ HTH Bob "Bob Phillips" wrote in message ... Try this array formula =SUM(A1:A5*0.585,A11:A20*0.55) as an array formula commit with Ctrl-Shift-Enter -- __________________________________ HTH Bob "TSA" wrote in message ... I want to take A1:A10 and multiply by .585 then... A:11:A20 multiplied by .55 = total result on A25 I went something like this....and it won't work: =sum(a1:a5)*.585+(a11:a20)*.55 All I get is #VALUE and the help prompts do not help. I am using Excel 2007 Any help appreciated |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Assistance | Excel Discussion (Misc queries) | |||
Formula assistance please??? | Excel Discussion (Misc queries) | |||
Formula assistance | Excel Discussion (Misc queries) | |||
Formula Assistance | New Users to Excel | |||
Assistance with Formula | Excel Worksheet Functions |