Feb 18 2021 06:45 PM - edited Feb 18 2021 06:47 PM
Hello all,
I can't seem to figure out the formula I need, let alone how to execute it.
I have a table which contains something such as:
amount amount amount total % Paid /Owing
$300 $400 $200 $900 15% P
$200 $200 $200 $600 10% O
$1000 $600 $500 $2100 35% P
$1000 $1000 $400 $2400 40% O
Total $2500 $2200 $1300 $6000 100%
Percentage of Paid = 50%
Percentage of Owing = 50%
I want a formula for the percentage paid and percentage owing.
I tried to use COUNTIFS to count the number of Ps and Os, but couldn't figure a way to relate them to the cell adjacent (%) to them.
It seems I need an IFS as well. I am completely lost on how to do this.
Appreciate any help with this.
Feb 18 2021 10:43 PM
Try the SUMIF function. Let's say % is in column F and paid/owing is in column G, then
=SUMIF(G2:G5,"P",F2:F5)
Feb 18 2021 10:49 PM
Feb 19 2021 06:13 PM
Feb 19 2021 06:15 PM
Feb 20 2021 08:51 PM
Feb 20 2021 10:35 PM
Surely whether an amount has been paid or not will be a matter of external fact and, as such, is input data rather than a calculation within Excel.
Mar 03 2021 02:17 PM
Feb 18 2021 10:43 PM
Solution