How to accumulate same cell entries using other cell value

[westcoastrocker]

Hi to all;

I'm new to this forum and know it will be very useful. I'm not so good at Excel and really will apprecite all the help I can find here.

My situation is that I'm trying to accumulate in a same cell different entries but using the result of another cell. For example I need to accumulate in cell A1 the result of cell B2 which is the multiplication of cells C1 with D1 and everytime I change D1 it will change B2 and this result will be accumulated in A1.

Thanks for any help you can give me.

[timtim89]

Hi westcoastrocker

Welcome to the forum!

For doing that you need a macro to accumulate the values. Check the attachment and enter the VBA (Alt + F11) for seeing the code (which is placed in Sheet1).

It accumulates values when you edit either c1 or d1. Let me know if this does what you are looking for.


Timo

[westcoastrocker]

Hi Timo;

Thanks for your fast response. I looked at the link and it is ok, when i entered the values of c1 and d1 it did its calculation on b1 but it didn't bring the result to a1 where it is supposed to do the accumulation of result in b1.

Thanks again, I really appreciate your help.

[timtim89]

Did you allow for macros when opening excel? Does anything (a zero) appear in a1? Mine is working when I enter number into c1 and d1..

[westcoastrocker]

You were right, I'm very sorry for that. I think I just opened the link and didn'n read the macro enable message. Thanks for your help, it is exactly what I was looking for.

[timtim89]

Glad to hear you figured it out and thanks for adding to my reputation Have a good weekend!