I have a spreadsheet that calculates the weighted average cost per share using =SUMPRODUCT based on price paid and # shares bought. Simple enough. It does some other stuff as well. A copy is attached.
I've been racking my brain trying to figure out how to calculate the cost per shares remaining, when taking into account the shares sold/the sale price. I've gone in circles for hours and done a ton of googling. Is this even possible? Please help.
Thanks in advance.