Hey All,
I'm trying to calculate a weighted return for a portfolio. I would like to use the GEOMEAN function, but am having trouble with zeros and negative numbers. I would like the geomean to include negative numbers but ignore the zeros. I have attached a sample sheet for reference.
Please let me know if I am not explaining this clearly.
Any help would be appreciated.
Thank You
Bookmarks