In Over My Head - Multiple Column Percentages

C

cybergardener

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?
 
B

bpeltzer

Start by checking out the countif function. For example,
=countif(a2:d2,"Yes"). You may need to calculate ratios of multiple
countifs.
Ex: =countif(a2:d2,"Yes") / (countif(a2:d2,"Yes")+countif(a2:d2,"No")).
 
B

Biff

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
 
D

Dave Peterson

=countif(e1:e20,"yes")/20
(E1:E20 has 20 cells)
format as percentage.

or
=countif(e1:e20,"yes")/(countif(e1:e20,"yes")+countif(e1:e20,"no"))
this is equivalent:
=countif(e1:e20,"yes")/sum(countif(e1:e20,{"yes","no"}))
 
C

cybergardener

Thank you for the Great Answer, it made my day.
--
Thanks
Cyber Gardener


Biff said:
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
Click to expand...
 
C

cybergardener

Hey Dave,

Works like a charm. Thanks so much for the help.
--
Thanks
Cyber Gardener


Dave Peterson said:
=countif(e1:e20,"yes")/20
(E1:E20 has 20 cells)
format as percentage.

or
=countif(e1:e20,"yes")/(countif(e1:e20,"yes")+countif(e1:e20,"no"))
this is equivalent:
=countif(e1:e20,"yes")/sum(countif(e1:e20,{"yes","no"}))
Click to expand...
 
C

cybergardener

One more thing please for n/a. How do I calculate the formula if a n/a is
entered and should be counted as a yes.
 
Top