Hi, if I have a list, for instance,
<TABLE style="WIDTH: 247pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=329 border=0><COLGROUP><COL style="WIDTH: 130pt; mso-width-source: userset; mso-width-alt: 6326" width=173><COL style="WIDTH: 117pt; mso-width-source: userset; mso-width-alt: 5705" width=156><TBODY><TR style="HEIGHT: 15.75pt" height=21><TD class=xl67 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf 0.5pt solid; BORDER-LEFT: #bfbfbf 0.5pt solid; WIDTH: 130pt; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: #0f253f" width=173 height=21>Name</TD><TD class=xl67 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf 0.5pt solid; BORDER-LEFT: #bfbfbf; WIDTH: 117pt; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: #0f253f" width=156>QA Score</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Aaron Cartin Salazar</TD><TD class=xl65 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent">95</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Adolfo Quiros</TD><TD class=xl65 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent">96</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Alberto Gomez Navarro</TD><TD class=xl65 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent">97</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl66 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Alejandro Navarro Marin</TD><TD class=xl66 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent">98</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Alejandro Solano Ortiz</TD><TD class=xl65 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent">99</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Andrea Castro Cubillo</TD><TD class=xl65 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent">100</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Andrey Zamora Mora</TD><TD class=xl65 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent">99</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Ariana Salazar Guzman</TD><TD class=xl65 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent">98</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Carlos Ballestero Jamienson</TD><TD class=xl65 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent">97</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Aaron Cartin Salazar</TD><TD class=xl65 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent">96</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Adolfo Quiros</TD><TD class=xl68 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent">98</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Alberto Gomez Navarro</TD><TD class=xl68 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent">98</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl66 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Alejandro Navarro Marin</TD><TD class=xl68 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent">99</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Alejandro Solano Ortiz</TD><TD class=xl69 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent">99</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Andrea Castro Cubillo</TD><TD class=xl68 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent">99</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Andrey Zamora Mora</TD><TD class=xl68 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent">99</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Ariana Salazar Guzman</TD><TD class=xl68 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent">99</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Carlos Ballestero Jamienson</TD><TD class=xl68 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent">99</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Aaron Cartin Salazar</TD><TD class=xl68 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent">100</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Adolfo Quiros</TD><TD class=xl68 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent">100</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Alberto Gomez Navarro</TD><TD class=xl68 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent">100</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl66 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Alejandro Navarro Marin</TD><TD class=xl68 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent">100</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Alejandro Solano Ortiz</TD><TD class=xl68 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent">100</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Andrea Castro Cubillo</TD><TD class=xl69 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent">100</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Andrey Zamora Mora</TD><TD class=xl68 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent">100</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Ariana Salazar Guzman</TD><TD class=xl68 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent">100</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Carlos Ballestero Jamienson</TD><TD class=xl68 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent">80</TD></TR></TBODY></TABLE>
I want to count the times an specific name appears I am using (without the apostrophe, used it just to show formula):
<TABLE style="WIDTH: 247pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=329 border=0><COLGROUP><COL style="WIDTH: 130pt; mso-width-source: userset; mso-width-alt: 6326" width=173><COL style="WIDTH: 117pt; mso-width-source: userset; mso-width-alt: 5705" width=156><TBODY><TR style="HEIGHT: 15.75pt" height=21><TD class=xl69 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf 0.5pt solid; BORDER-LEFT: #bfbfbf 0.5pt solid; WIDTH: 130pt; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: #0f253f" width=173 height=21>Name</TD><TD class=xl69 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf 0.5pt solid; BORDER-LEFT: #bfbfbf; WIDTH: 117pt; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: #0f253f" width=156>QA monitors</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl67 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Aaron Cartin Salazar</TD><TD class=xl67 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent">+countif(I18:I44=I5)'</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl67 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Adolfo Quiros</TD><TD class=xl67 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl67 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Alberto Gomez Navarro</TD><TD class=xl67 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl68 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Alejandro Navarro Marin</TD><TD class=xl68 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl67 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Alejandro Solano Ortiz</TD><TD class=xl67 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl67 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Andrea Castro Cubillo</TD><TD class=xl67 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl67 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Andrey Zamora Mora</TD><TD class=xl67 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl67 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Ariana Salazar Guzman</TD><TD class=xl67 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl67 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Carlos Ballestero Jamienson</TD><TD class=xl67 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent"></TD></TR></TBODY></TABLE>
It gives me an error.....
and I don't know how to average by name, I know how to do it but only with a pivot, any ideas on a formula I can use to average by name?
Thanks!!!
<TABLE style="WIDTH: 247pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=329 border=0><COLGROUP><COL style="WIDTH: 130pt; mso-width-source: userset; mso-width-alt: 6326" width=173><COL style="WIDTH: 117pt; mso-width-source: userset; mso-width-alt: 5705" width=156><TBODY><TR style="HEIGHT: 15.75pt" height=21><TD class=xl67 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf 0.5pt solid; BORDER-LEFT: #bfbfbf 0.5pt solid; WIDTH: 130pt; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: #0f253f" width=173 height=21>Name</TD><TD class=xl67 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf 0.5pt solid; BORDER-LEFT: #bfbfbf; WIDTH: 117pt; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: #0f253f" width=156>QA Score</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Aaron Cartin Salazar</TD><TD class=xl65 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent">95</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Adolfo Quiros</TD><TD class=xl65 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent">96</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Alberto Gomez Navarro</TD><TD class=xl65 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent">97</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl66 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Alejandro Navarro Marin</TD><TD class=xl66 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent">98</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Alejandro Solano Ortiz</TD><TD class=xl65 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent">99</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Andrea Castro Cubillo</TD><TD class=xl65 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent">100</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Andrey Zamora Mora</TD><TD class=xl65 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent">99</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Ariana Salazar Guzman</TD><TD class=xl65 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent">98</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Carlos Ballestero Jamienson</TD><TD class=xl65 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent">97</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Aaron Cartin Salazar</TD><TD class=xl65 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent">96</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Adolfo Quiros</TD><TD class=xl68 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent">98</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Alberto Gomez Navarro</TD><TD class=xl68 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent">98</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl66 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Alejandro Navarro Marin</TD><TD class=xl68 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent">99</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Alejandro Solano Ortiz</TD><TD class=xl69 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent">99</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Andrea Castro Cubillo</TD><TD class=xl68 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent">99</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Andrey Zamora Mora</TD><TD class=xl68 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent">99</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Ariana Salazar Guzman</TD><TD class=xl68 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent">99</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Carlos Ballestero Jamienson</TD><TD class=xl68 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent">99</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Aaron Cartin Salazar</TD><TD class=xl68 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent">100</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Adolfo Quiros</TD><TD class=xl68 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent">100</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Alberto Gomez Navarro</TD><TD class=xl68 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent">100</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl66 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Alejandro Navarro Marin</TD><TD class=xl68 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent">100</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Alejandro Solano Ortiz</TD><TD class=xl68 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent">100</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Andrea Castro Cubillo</TD><TD class=xl69 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent">100</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Andrey Zamora Mora</TD><TD class=xl68 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent">100</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Ariana Salazar Guzman</TD><TD class=xl68 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent">100</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Carlos Ballestero Jamienson</TD><TD class=xl68 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent">80</TD></TR></TBODY></TABLE>
I want to count the times an specific name appears I am using (without the apostrophe, used it just to show formula):
<TABLE style="WIDTH: 247pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=329 border=0><COLGROUP><COL style="WIDTH: 130pt; mso-width-source: userset; mso-width-alt: 6326" width=173><COL style="WIDTH: 117pt; mso-width-source: userset; mso-width-alt: 5705" width=156><TBODY><TR style="HEIGHT: 15.75pt" height=21><TD class=xl69 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf 0.5pt solid; BORDER-LEFT: #bfbfbf 0.5pt solid; WIDTH: 130pt; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: #0f253f" width=173 height=21>Name</TD><TD class=xl69 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf 0.5pt solid; BORDER-LEFT: #bfbfbf; WIDTH: 117pt; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: #0f253f" width=156>QA monitors</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl67 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Aaron Cartin Salazar</TD><TD class=xl67 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent">+countif(I18:I44=I5)'</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl67 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Adolfo Quiros</TD><TD class=xl67 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl67 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Alberto Gomez Navarro</TD><TD class=xl67 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl68 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Alejandro Navarro Marin</TD><TD class=xl68 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl67 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Alejandro Solano Ortiz</TD><TD class=xl67 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl67 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Andrea Castro Cubillo</TD><TD class=xl67 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl67 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Andrey Zamora Mora</TD><TD class=xl67 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl67 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Ariana Salazar Guzman</TD><TD class=xl67 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl67 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #bfbfbf 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Carlos Ballestero Jamienson</TD><TD class=xl67 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #bfbfbf; BORDER-LEFT: #bfbfbf; BORDER-BOTTOM: #bfbfbf 0.5pt solid; BACKGROUND-COLOR: transparent"></TD></TR></TBODY></TABLE>
It gives me an error.....
and I don't know how to average by name, I know how to do it but only with a pivot, any ideas on a formula I can use to average by name?
Thanks!!!