Column calculation problems

[ksfarmer]

I have a situation. Here's the set up

4 columns x 60 rows. Let's say column A B C D.
I want to be able on each row to make multiple entries of numbers in Column
A.
Have it added to total in column B.
Multiplied by number in column C.
Then the accumulating extended value stored in column D

Any takers on helping here?

Thanks in advance for any help

 

[Sheeloo]

Do you want sum of the value in cell A1 and cell B1 multiplied by value in C1
and stored in D1? If yes, then enter this in D1
=(A1+B1)*C1

You can copy and paste this formula down Col D...

 

[ksfarmer]

Thanks for the reply,

What I am after is to enter many DIFFERENT quantities in column A1. Each
time the quantity is entered in Column A1 it will be accumulated in column
B1.

A unit price will have been entered in Column C1. The amount in column B1
will be multiplied by the price in column C1. The result will be stored in
column D1.

This process will be repeated in Rows 1 through 60. Then a sum total will
be done on colum D1 through D60 for a grand total.

Sorry to have been so vague in the initial entry.

thanks

 

[Sheeloo]

So you want to, say, enter 10 in A1 such that B1 is also 10.
Then you want to enter another number in A1, say 50, and want B1 to now show
60!

That can NOT be done using a formula. You need to develop a macro using VBA
to do that.

One of the way you can do this is to start entering your numbers from E1,
then enter the next number in F1, and so on, say upto Z1. Then you can have
this in B1
=SUM(E:Z1)
and this in D1
=B1*C1

After you use the cells upto Z1, you can then enter the number in B1 in E1,
delete the numbers from F1 to Z1 and start entering the numbers again from F1
to Z1...