need formula for % of times text appears in row.
 

Hi. I need help with with calculating the percentage of times
a specific text appears within a row.
The formula needs to be relative, so I can copy and paste it
into successive rows.

e.g. Based on the text in A2:D2, what are the percentages
for €œx,€� €œy,€� €œz€� in that range?

____________________________________

__ |_A_|_B_|_C_|_D_| _E_ |__F_ |_ G_ |__
1 | | | | | %x | %y | %z |

2 | z | y | z | x | 25 | 25 | 50 |

_____________________________________


(Thus, row 2 is comprised of 25% X, 25% Y, 50% Z.
Can someone help me with this?)

Thank you,
Bob

need formula for % of times text appears in row.
 

Based on your example:

in E2:

=COUNTIF($A2:$D2,E1)/COUNTA($A2:$D2) where E1="x"

Copy across to cells F2 & G2 and copy down as required

Cells are formatted as %.

HTH

"sunslight" wrote:

Hi. I need help with with calculating the percentage of times
a specific text appears within a row.
The formula needs to be relative, so I can copy and paste it
into successive rows.

e.g. Based on the text in A2:D2, what are the percentages
for €œx,€� €œy,€� €œz€� in that range?

____________________________________

__ |_A_|_B_|_C_|_D_| _E_ |__F_ |_ G_ |__
1 | | | | | %x | %y | %z |

2 | z | y | z | x | 25 | 25 | 50 |

_____________________________________


(Thus, row 2 is comprised of 25% X, 25% Y, 50% Z.
Can someone help me with this?)

Thank you,
Bob

need formula for % of times text appears in row.
 

Hi

=contif($a2:$d2,right(e1,1))/counta($a2:$d2)

copy it right and down as you need

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"sunslight" escreveu:

Hi. I need help with with calculating the percentage of times
a specific text appears within a row.
The formula needs to be relative, so I can copy and paste it
into successive rows.

e.g. Based on the text in A2:D2, what are the percentages
for €œx,€� €œy,€� €œz€� in that range?

____________________________________

__ |_A_|_B_|_C_|_D_| _E_ |__F_ |_ G_ |__
1 | | | | | %x | %y | %z |

2 | z | y | z | x | 25 | 25 | 50 |

_____________________________________


(Thus, row 2 is comprised of 25% X, 25% Y, 50% Z.
Can someone help me with this?)

Thank you,
Bob