In Over My Head - Multiple Column Percentages
 

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

In Over My Head - Multiple Column Percentages
 

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")).

"cybergardener" wrote:

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

In Over My Head - Multiple Column Percentages
 

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

In Over My Head - Multiple Column Percentages
 

=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"}))





cybergardener wrote:

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

--

Dave Peterson

In Over My Head - Multiple Column Percentages
 

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


"Biff" wrote:

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

In Over My Head - Multiple Column Percentages
 

Hey Dave,

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


"Dave Peterson" wrote:

=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"}))





cybergardener wrote:

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

--

Dave Peterson

In Over My Head - Multiple Column Percentages
 

Works great. Thanks, you are a life saver.
--
Thanks
Cyber Gardener


"bpeltzer" wrote:

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")).

"cybergardener" wrote:

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

In Over My Head - Multiple Column Percentages
 

You're welcome!

Biff

"cybergardener" wrote in message
...
Thank you for the Great Answer, it made my day.
--
Thanks
Cyber Gardener


"Biff" wrote:

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

In Over My Head - Multiple Column Percentages
 

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.
--
Thanks
Cyber Gardener


"bpeltzer" wrote:

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")).

"cybergardener" wrote:

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