Countif and average

U

u173317

New Member
Joined
Nov 19, 2011
Messages
11
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!!!
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.
Sort by date Sort by votes
For the count =COUNTIF(I18:I44,I5)

for the average =SUMIF(I18:I44,I5,J18:J44)/COUNTIF(I18:I44,I5)
 
Upvote 0
Hi

You should always post your excel version (for ex., add it to your board signature).

If you have a recent version of excel, try:

=AVERAGEIF(I18:I44,I5,J18:J44)
 
Upvote 0
u173317 said:
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!!!
Click to expand...
Here's another one...

Let's assume your data is in the range A2:B28.

You have a summary area like this:

Book1
DEF
1NameCountAverage
2Aaron Cartin Salazar__
3Adolfo Quiros__
4Alberto Gomez Navarro__
5Alejandro Navarro Marin__
6Alejandro Solano Ortiz__
7Andrea Castro Cubillo__
8Andrey Zamora Mora__
9Ariana Salazar Guzman__
10Carlos Ballestero Jamienson__
Sheet1

Enter this formula in E2:

=COUNTIF(A$2:A$28,D2)

Enter one of these formulas in F2:

If you're using Excel 2007 or later:

=AVERAGEIF(A$2:A$28,D2,B$2:B$28)

This array formula** will work in all versions of Excel:

=AVERAGE(IF(A$2:A$28=D2,B$2:B$28))

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

Select both E2 and F2 then copy down as needed.
 
Upvote 0
You must log in or register to reply here.

Similar threads

G
  • Question
Using Excel formula to create HTML code text referencing specific cells
Replies
0
Views
864
gvsumich
G
A
  • Question
VBA - Automatically Break the Line in HTML format.
Replies
7
Views
1K
Attrazion
A
E
  • Question
VBA for Web Scraping help
Replies
0
Views
622
epactheactor
E
C
  • Solved
Excel 2016 32bit VBA Pulling info from Website to Sheet
Replies
2
Views
1K
CrashOD
C
E
  • Question
Query in excel to Outlook mail take rows with name until next name
Replies
0
Views
364
esben
E

Forum statistics

Threads
1,216,084
Messages
6,128,728
Members
449,465
Latest member
TAKLAM

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top