ExcelBanter - Formula help?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Formula help? (https://www.excelbanter.com/excel-worksheet-functions/216729-formula-help.html)

Tom

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

Eduardo

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

Mike H

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

All times are GMT +1. The time now is 07:42 AM.