SUMIF across three rows

Hello everyone,

I'm attempting to create a formula that will add all three rows together. I've tried:

=SUMIF([Amount Written off]:[AmountWritten off], [Amount of feesWaived]:[Amount of fees Waived], [Attorney fees]:[Attorney fees])

I've also tried =SUM([Amount of fees Waived]:[Amount of fees Waived],+=SUM([Amount Written off]:[Amount Written off],+=SUM([Attorney fees]:[Attorney fees]

Not sure what I'm missing here, any advice is more than appreciated, thank you!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!