# Difference between already paid and total paid

Options
✭✭✭✭

Hey there,

is there a way to automatically calculate the difference between

• total to pay

amount when status is "payment planned" or "invest planned"

or is it better to have another column "already paid" and to build a formula there

that calculates "total amount (frequency)" x frequency since start of payment ?

• ✭✭✭✭✭✭
Options

You can thread SUMIF or SUMIFS functions within IF statements. So you could do something like:

=IF(Zahlungsstatus@row="Investition geplant", SUMIF

and then nest another IF statement into the false condition of the first.

• ✭✭✭✭
Options

do you have an idea for a formula in my 2nd sheet "bill status overview"

I want to calculate "total sum yearly" minus "already paid amount" (that changes according to chosen payment mode f.e. if it is monthly payment, payment starts on January 1st and it is February 3rd I already had two payments

first example in screenshot: 222,07 € minus 37,02 € (18,51 x 2) = 185,05 € open amount in January because payment start in December 22.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!