For some reason, I can't figure out why this isn't working. Column is all currency. I need G2 to eventually get to $0 when I put in my amounts in G10 to G? I have tried using positive and negative numbers. How I think my formula should look: =600-(G10+G100) Keep getting error. Or =600-(G10:G100) gets error too. Also have tried
=G10-(G10:G100)

Hi
as external links are potentially unsafe and not accessible to all members, I removed the one you posted.
Could you please post a sample sheet ( no pics pse) showing your data and expected results? Thanks

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Maybe:

=600-SUM(G10:G100)


=600 - (G10:G100) doesn't give any result. However:

=600-(G10+G100) should give a result if you have numbers in G10 and G100.

So this one works
=600-SUM(G10:G100)


Thank you so much!!!