I have a yearly spreadsheet with monthly percentages, but how to I have a running total of the percentages
2006-11-15 03:06:58 · 5 answers · asked by elizabeth k 1 in Science & Mathematics ➔ Mathematics
You have to work out the actual proportions- multiply the total by the percentage over 100 for each month, add these all together, and then divide by the total for the year (and multiply by 100)
2006-11-15 03:18:35 · answer #1 · answered by Anonymous · 0⤊ 0⤋
Hi,
Your going to have to give more detail on this one...for example:
You can express the percentages as a yearly average or you can give them as precise monthly percentages on a graph...it really depends on what you want to do..but you question is kinda odd, since your percentage is expressed as a monthly figure..why would you want to add it up?
Are you trying to arrive at a yearly average?
2006-11-15 03:19:06 · answer #2 · answered by Pedro 2 · 0⤊ 0⤋
You can use the sum feature "=sum(cellX:cellx)". The percentages should add up to 100% and it will update as you change numbers. Of course, cellX and cellx are the range of cells you want to add up.
2006-11-15 03:10:04 · answer #3 · answered by M H 3 · 0⤊ 0⤋
try winpossible.com cool site may help you
2006-11-15 03:10:25 · answer #4 · answered by sandywin2006 1 · 0⤊ 1⤋
to a hundred.
2006-11-15 03:08:21 · answer #5 · answered by nobudE 7 · 0⤊ 0⤋