Difference between already paid and total paid
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 ?
Answers

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.

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
Categories
Check out the Formula Handbook template!