enterenter
New Member
Hi,
I did a excel to find a average cost. It need to calculate the row by row.
I have 2 questions
Q1) Is there any formulae or shortcuts (without column H, I, J) to get the final average cost 57.47 directly?
Q2) Is there any formulae or shortcuts (without column H, I, J) to get the average cost for a pointed row ?
or Can I input a transaction number to check the average price after finished that transaction.
e.g. After finished 8 transactions, I input transaction 3 to excel, it show 79.48
Thanks a lot!
I did a excel to find a average cost. It need to calculate the row by row.
I have 2 questions
Q1) Is there any formulae or shortcuts (without column H, I, J) to get the final average cost 57.47 directly?
Q2) Is there any formulae or shortcuts (without column H, I, J) to get the average cost for a pointed row ?
or Can I input a transaction number to check the average price after finished that transaction.
e.g. After finished 8 transactions, I input transaction 3 to excel, it show 79.48
Thanks a lot!