At the end of each section there is a percentage score, at the bottom I want to have an overall percentage of all the sections how can I do this?In excel I have a spreadsheet that is split into 7 sections?
You cannot add percentages.
To get the total you have to use ALL the data from all the seven sections more or less ignoring the seven sub-percentagesIn excel I have a spreadsheet that is split into 7 sections?
=CELL1+CELL2+CELL3 etc
Format the cell to percentage and there you go. Note where I wrote CELL1 replace it with the cell coordinates.
Hope this helps.
Dan
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment