Difference between already paid and total paid

Jörg Schmidt1

Hey there,

is there a way to automatically calculate the difference between

• already paid
• 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 ?

Mike TV

@Jörg Schmidt1

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.