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.
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 !!