Formula assistance

[TSA]

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

 

[Ashish Mathur]

Hi,

Try this

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

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[Bob Phillips]

Try this array formula

=SUM(A1:A5*0.585,A11:A20*0.55)

as an array formula commit with Ctrl-Shift-Enter

 

[David Biddulph]

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.

 

[Bob Phillips]

slight correction

=SUM(A1:A10*0.585,A11:A20*0.55)

still array entered