SUMIF across three rows

Question

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!

Nic Larsen · Accepted Answer

Try: =SUM([Amount of fees Waived]:[Amount of fees Waived]) + SUM([Amount Written off]:[Amount Written off]) + SUM([Attorney fees]:[Attorney fees])