| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula help
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 help
=sum(a1:a5)*.585+sum(a11:a20)*.55
"Tom" wrote: 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 help
I went something like this....and it won't work:
=sum(a1:a5)*.585+(a11:a20)*.55 All I get is #VALUE You just need a second SUM function: =SUM(A1:A10)*0.585+SUM(A11:A20)*0.55 Could also be written like this: =SUMPRODUCT((A1:A10*0.585)+(A11:A20*0.55)) -- Biff Microsoft Excel MVP "Tom" 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 | |
|
|
Linear Mode
