This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(166.4, 79%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELW%3C/text%3E%3C/svg%3E)
I have four figures in different cells and need to calculate from those figures, what percentage out of 100% was the satisfaction rate. I've created a formula but it only looks at two cells, I've tried to amend it but can't get it to work. Can anybody help please? I have attached the book. TIA, Louise https://louisewooding-my.sharepoint.com/:x:/g/personal/louise_louisewooding_onmicrosoft_com/EUej1YgucfRIvStBAZB4GNoB586zrd0yC3DMvXqPmQGe9g?e=daiMti
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Hello. You can use this formula: =(C4 + D4 + E4) / (B4 * 3)
Do you also want to include B4 in the calculation?
Brilliant! Thank you so much, I would never have thought of that! Louise :)
sorry, only just seen your question, do I want to include b4 in the calculation. I need it to look at how many people attended the training, and then look at the figures in the adjoining 3 cells to calculate the overall satisfaction as a percentage from their scores. Does that make sense? So if I had 8 people, and some said they would recommend the training but some said they wouldn't etc, I need the overall percentage of those scores.
Perfect, if that's the case then the formula is good for you :) No changes needed.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(188.79999999999998, 22%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWS%3C/text%3E%3C/svg%3E)
The formula in the accepted answer is right for your case: add the three score cells, then divide by (attendees × 3). The ×3 is there because each attendee gives three scores, so B4×3 is the maximum total you could have got. Format the result cell as a percentage, or multiply by 100 if you want the plain number. A quick check with your numbers: if 8 people attended and the three cells add up to 20, that is 20/(8×3) = 0.833, so about 83% overall satisfaction. One thing to watch: if anyone left a question blank, count only the scores actually given — a missing answer counted as zero drags the average down unfairly.