Total sum of results of a formula?

Options

I have a formula to calculate payouts as follows:

=IF(AND([Estimated New Annual (ACV) Net Booking $ Amount]@row >= 75000, [Estimated New Annual (ACV) Net Booking $ Amount]@row <= 250000), "$2500", IF(AND([Estimated New Annual (ACV) Net Booking $ Amount]@row >= 251000, [Estimated New Annual (ACV) Net Booking $ Amount]@row < 1000000), "$5000", IF([Estimated New Annual (ACV) Net Booking $ Amount]@row >= 100000, "$10000")))

I would like to total this column so I can see the total payout, but it doesn't work and returns a value ZERO.

Is it possible to sum the total of the "results" of the formula above?

Tags:

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!