Hi!

Try this:

For % of Yes:

=COUNTIF(A1:D1,"yes")/4

Format the cell as PERCENTAGE

You can follow the same example for "no" or "+" or "-".

Biff

"cybergardener" wrote in message
...
Can I get a percent ratio from multiple columns that uses letters or
characters? For example 4 columns with random Yes or No answers, 3 yes, 1
no, should show in Column E 75% in favor of Yes.

There are also similar columns with the + and - signs instead of a word or
numbers. Can these symbols be calculated?
--
Thanks
Cyber Gardener