View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Formula challenged Formula challenged is offline
external usenet poster
 
Posts: 1
Default How to enter a constant sum formula using values from 2 different

I am trying to program a spread sheet to track the average cost per share of
stock based on periodic investments and sales of the stock. Want to have a
column which will show the average cost per share of every purchase as well
as another which will show average cost of all shares being held.

Thanks for your assistance.