#Values! is caused by "-" from the Cells.
what I have noticed on that Sheet, is that the $ sign is entered Manually and importantly the "-" (for blank entries).
if you do a simple Sum() to O column it will result into 0 (because of those Text).
the OP need to remove those "-" from column O and just Format the Cells (that will show "-" instead of blank).
if you do these suggestions the New Formula will work.
