Forum Discussion
Solved
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 % ...
FilmExcel Use SUMIF as demonstrated in the picture below.
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.
- That's correct. The example I provided is a bit bad since it provides 50% for each category. But what I wanted was to enter either letter manually on a big budget sheet and then see the percentage of owed and paid.
As such, it'll be easier to calculate a percentage by having a letter to differentiate between each row when it was paid or still owing. So that with time, as we manually updated the Os to Ps, until the Paid is 100% and Owed is 0%.
- Thanks, replaced the A9 with “P” and O accordingly as JMB17 put it.
Works like a dream.
