Sum 2 Ranges and put resulta in other Range

[Burita]

Hi.
I have a book with some records that i want to sum some values in 2 ranges and put the results in one other range, but i can't do this. I have:

Please Login or Register  to view this content.

This Works for a single cell, but i want for a range of cells. For exemple (This is like pseudocode....)

Please Login or Register  to view this content.

Get the ideia? It is possible to do it?
Thanks.... and sorry my bad English

[Richard Buttrey]

Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

To upload a file click the Go Advanced button at the foot of your post, look underneath the post area for the Manage Attachments section and take it from there.

[jomaor1]

Hi,

Assuming you have data in AA2 & AF2, and you want to sum in AG2,
How about:

Please Login or Register  to view this content.

[AliGW]

Administrative Note:

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

[Burita]

Hi again.
Richard i already attach the file. Sorry...

jomaor1 i put the code in the file but gives a error.
I send the file with the error...

[Burita]

AliGW i already put the code between those tags.
Thanks for remind me.

[daboho]

Please Login or Register  to view this content.

[Burita]

daboho,
i put that code in my Project but gives a error "Out of Stack Space".
I attatch the file with the new code.

Thanks

[Burita]

Please,
someone give a help on this. I realy need it.

Thanks

[mohadin]

Please Login or Register  to view this content.

maybe

[Burita]

mohadin,
this gives the total sum of the collumnA and collumnB int every cell in collumn C
See attach.

Thanks