Formula help

[Tom]

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

 

[Teethless mama]

=sum(a1:a5)*.585+sum(a11:a20)*.55

 

[T. Valko]

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))