do you want a sum or you want Col J to return the highest value?
if it is the latter, use =MAX(G5:I5)
if you want a total, simply do a =SUM(range:range), but I don't understand
your requirement
if you need this as there's no good data for analysis.

Let me know if this work for you, if not, post with a sample of result you
want
--
HTH

Pls provide your feedback by clicking the YES button below if this posting
is helpful
This will help others to search the results in the archive better

cheers, francis

"Wendy-Bob" wrote in message
...
Hiya,

This is probably a walk in the park for most of you but I'm stumped!

I have a spreadsheet which analyses reference requests. In the character
section, feedback is requested on 10 items. Each item can be graded
"good",
"satisfactory" or "needs improving". On my spreadsheet I want a sum to
auto-input the majority answer.

The data looks like this:

G H I J
Good Satisfactory Needs Improving Majority
5 10 0 0
6 4 6 0
7 2 1 7
8 5 5 0

I need a formula for column J. I also have the problem that sometimes (as
in
row 8) there can be identical numbers for different levels of performance.

I have been playing about with IFs but have yet to come up with something
functional. To be honest, I'm not sure whether I'm even using the right
function for something like this.

Any help would be greatly appreciated!

Thank you.