percentage

[trisham]

Hi so I have an audit that I do every week, and I basically take every client and they have 4 sections each worth 25pts adding up to a total of 100 I am having to do multiple clients now rather than just one, so what I need is a formula that gives me an overall percent for each section. please see the attached let me know if you have any questions.

[Richard Buttrey]

Hi,

Does the attached help.

formulae like

Please Login or Register  to view this content.

in O5 and

Please Login or Register  to view this content.

in N5 copid down where relevant.

[trisham]

does that include the blank spaces?

[trisham]

I need the rows to add up not just column o. I need each section of to show the percents out of 100? I dont know if that makes sense, please let me know

[Richard Buttrey]

I need the rows to add up not just column o. I need each section of to show the percents out of 100? I dont know if that makes sense, please let me know

Sorry, but I don't understand what you mean by "I need the rows to add up ". If you want totals for N8, N12, N18 etc. then just add a bog standard =SUM() function.

Neither do I understand " I need each section to show the percents out of 100" What do you mean by a section? You've chosen to merge O5:O7 so I assumed that's a section, and since it's merged you clearly weren't looking for a % for each row. Hence it seemed to me you wanted a % of the total points (320) on row 22.

If this is not what you want then manually add the results you DO want and upload the workbook again.