I need to track investment performance by month. My worksheet includes columns for sales and columns for purchases and resulting values in other columns. How can I create a cell that shows the total of multiple transactions? For instance:
date 1 shares cost market gain/loss and so on
date 2 shares cost market gain/loss and so on
I need to summarize these transactions on one line so subsequent columns calculate accurately. The cell would contain a drop down indicator.