Forum Discussion
Can't seem to figure out a formula to do the following
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.
FilmExcel Use SUMIF as demonstrated in the picture below.
9 Replies
- I'm unable to simplify that how you get P & O, if considering Percentage of Paid = 50% and Percentage of Owing = 50%, none of the cells meets this criteria,, also write that you are considering % of which for P & O,, ROW or COLUMN total !!
- This is perfect, thanks. I was over complicating it.
FilmExcel Use SUMIF as demonstrated in the picture below.
- The million dollar question is that how OP is getting P & O in column G ,, what the mechanism behind, otherwise getting % for both is not a big issue!!
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.
- Thanks, replaced the A9 with “P” and O accordingly as JMB17 put it.
Works like a dream.
