| 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?
Hi Tom
You were close =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?
Tom,
You were close, try this =SUM(A1:A10)*0.585+SUM(A11:A20)*0.55 Mike "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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
