STDEV.P formula

robfl22

Board Regular
Joined
Jan 29, 2009
Messages
87
I have a Table and I am trying to come up with a STDEV.P formula to find the Overall SD of each NBA team points scored and points allowed in games they have played so far. However, the table has the entire NBA season schedule already loaded meaning that there will be blank spaces in games that have not been played yet. I figured out how to calculate the Standard Deviations for JUST Away Games and Home Games for each Team. But my problem is figuring out a formula is getting the standard deviation overall. Any help would be appreciated.

DateAway TeamHome TeamAway ScoreHome Score
10/19/2021​
Brooklyn NetsMilwaukee Bucks
104​
127​
10/19/2021​
Golden State WarriorsLos Angeles Lakers
121​
114​
10/20/2021​
Indiana PacersCharlotte Hornets
122​
123​
10/20/2021​
Chicago BullsDetroit Pistons
94​
88​
10/20/2021​
Boston CelticsNew York Knicks
134​
138​
10/20/2021​
Washington WizardsToronto Raptors
98​
83​
10/20/2021​
Cleveland CavaliersMemphis Grizzlies
121​
132​
10/20/2021​
Houston RocketsMinnesota Timberwolves
106​
124​
10/20/2021​
Philadelphia 76ersNew Orleans Pelicans
117​
97​
10/20/2021​
Orlando MagicSan Antonio Spurs
97​
123​
10/20/2021​
Oklahoma City ThunderUtah Jazz
86​
107​
10/20/2021​
Sacramento KingsPortland Trail Blazers
124​
121​
10/20/2021​
Denver NuggetsPhoenix Suns
110​
98​
10/21/2021​
Dallas MavericksAtlanta Hawks
87​
113​
10/21/2021​
Milwaukee BucksMiami Heat
95​
137​
10/21/2021​
LA ClippersGolden State Warriors
113​
115​
10/22/2021​
New York KnicksOrlando Magic
121​
96​
10/22/2021​
Indiana PacersWashington Wizards
134​
135​
10/22/2021​
Charlotte HornetsCleveland Cavaliers
123​
112​
10/22/2021​
Toronto RaptorsBoston Celtics
115​
83​
10/22/2021​
Brooklyn NetsPhiladelphia 76ers
114​
109​
10/22/2021​
Oklahoma City ThunderHouston Rockets
91​
124​
10/22/2021​
New Orleans PelicansChicago Bulls
112​
128​
10/22/2021​
San Antonio SpursDenver Nuggets
96​
102​
10/22/2021​
Phoenix SunsLos Angeles Lakers
115​
105​
10/22/2021​
Utah JazzSacramento Kings
110​
101​
10/23/2021​
Atlanta HawksCleveland Cavaliers
95​
101​
10/23/2021​
Miami HeatIndiana Pacers
91​
102​
10/23/2021​
Dallas MavericksToronto Raptors
103​
95​
10/23/2021​
Detroit PistonsChicago Bulls
82​
97​
10/23/2021​
New Orleans PelicansMinnesota Timberwolves
89​
96​
10/23/2021​
Milwaukee BucksSan Antonio Spurs
121​
111​
10/23/2021​
Phoenix SunsPortland Trail Blazers
105​
134​
10/23/2021​
Memphis GrizzliesLA Clippers
120​
114​
10/24/2021​
Charlotte HornetsBrooklyn Nets
111​
95​
10/24/2021​
Boston CelticsHouston Rockets
107​
97​
10/24/2021​
Orlando MagicNew York Knicks
110​
104​
10/24/2021​
Philadelphia 76ersOklahoma City Thunder
115​
103​
10/24/2021​
Golden State WarriorsSacramento Kings
119​
107​
10/24/2021​
Memphis GrizzliesLos Angeles Lakers
118​
121​
10/25/2021​
Boston CelticsCharlotte Hornets
140​
129​
10/25/2021​
Milwaukee BucksIndiana Pacers
119​
109​
10/25/2021​
Chicago BullsToronto Raptors
111​
108​
10/25/2021​
Orlando MagicMiami Heat
90​
107​
10/25/2021​
Washington WizardsBrooklyn Nets
90​
104​
10/25/2021​
Detroit PistonsAtlanta Hawks
104​
122​
10/25/2021​
New Orleans PelicansMinnesota Timberwolves
107​
98​
10/25/2021​
Cleveland CavaliersDenver Nuggets
99​
87​
10/25/2021​
Portland Trail BlazersLA Clippers
86​
116​
10/26/2021​
Philadelphia 76ersNew York Knicks
99​
112​
10/26/2021​
Golden State WarriorsOklahoma City Thunder
106​
98​
10/26/2021​
Los Angeles LakersSan Antonio Spurs
125​
121​
10/26/2021​
Houston RocketsDallas Mavericks
106​
116​
10/26/2021​
Denver NuggetsUtah Jazz
110​
122​
10/27/2021​
Charlotte HornetsOrlando Magic
120​
111​
10/27/2021​
Washington WizardsBoston Celtics
116​
107​
10/27/2021​
Miami HeatBrooklyn Nets
106​
93​
10/27/2021​
Indiana PacersToronto Raptors
100​
118​
10/27/2021​
Atlanta HawksNew Orleans Pelicans
102​
99​
10/27/2021​
Minnesota TimberwolvesMilwaukee Bucks
113​
108​
10/27/2021​
Los Angeles LakersOklahoma City Thunder
115​
123​
10/27/2021​
Sacramento KingsPhoenix Suns
110​
107​
10/27/2021​
Memphis GrizzliesPortland Trail Blazers
96​
116​
10/27/2021​
Cleveland CavaliersLA Clippers
92​
79​
10/28/2021​
Atlanta HawksWashington Wizards
111​
122​
10/28/2021​
Detroit PistonsPhiladelphia 76ers
102​
110​
10/28/2021​
Utah JazzHouston Rockets
122​
91​
10/28/2021​
New York KnicksChicago Bulls
104​
103​
10/28/2021​
San Antonio SpursDallas Mavericks
99​
104​
10/28/2021​
Memphis GrizzliesGolden State Warriors
104​
101​
10/29/2021​
Orlando MagicToronto Raptors
109​
110​
10/29/2021​
Charlotte HornetsMiami Heat
99​
114​
10/29/2021​
Indiana PacersBrooklyn Nets
98​
105​
10/29/2021​
Sacramento KingsNew Orleans Pelicans
113​
109​
10/29/2021​
Dallas MavericksDenver Nuggets
75​
106​
10/29/2021​
LA ClippersPortland Trail Blazers
92​
111​
10/29/2021​
Cleveland CavaliersLos Angeles Lakers
101​
113​
10/30/2021​
Boston CelticsWashington Wizards
112​
115​
10/30/2021​
Orlando MagicDetroit Pistons
103​
110​
10/30/2021​
New York KnicksNew Orleans Pelicans
123​
117​
10/30/2021​
Toronto RaptorsIndiana Pacers
97​
94​
10/30/2021​
Atlanta HawksPhiladelphia 76ers
94​
122​
10/30/2021​
Utah JazzChicago Bulls
99​
107​
10/30/2021​
Miami HeatMemphis Grizzlies
129​
103​
10/30/2021​
San Antonio SpursMilwaukee Bucks
102​
93​
10/30/2021​
Oklahoma City ThunderGolden State Warriors
82​
103​
10/30/2021​
Denver NuggetsMinnesota Timberwolves
93​
91​
10/30/2021​
Cleveland CavaliersPhoenix Suns
92​
101​
10/31/2021​
Sacramento KingsDallas Mavericks
99​
105​
10/31/2021​
Portland Trail BlazersCharlotte Hornets
113​
125​
10/31/2021​
Utah JazzMilwaukee Bucks
107​
95​
10/31/2021​
Detroit PistonsBrooklyn Nets
91​
117​
10/31/2021​
Houston RocketsLos Angeles Lakers
85​
95​
11/1/2021​
Cleveland CavaliersCharlotte Hornets
113​
110​
11/1/2021​
San Antonio SpursIndiana Pacers
118​
131​
11/1/2021​
Portland Trail BlazersPhiladelphia 76ers
103​
113​
11/1/2021​
Washington WizardsAtlanta Hawks
111​
118​
11/1/2021​
Chicago BullsBoston Celtics
128​
114​
11/1/2021​
Toronto RaptorsNew York Knicks
113​
104​
11/1/2021​
Denver NuggetsMemphis Grizzlies
97​
106​
11/1/2021​
Orlando MagicMinnesota Timberwolves
115​
97​
11/1/2021​
Oklahoma City ThunderLA Clippers
94​
99​
11/2/2021​
Milwaukee BucksDetroit Pistons
117​
89​
11/2/2021​
Miami HeatDallas Mavericks
125​
110​
11/2/2021​
Sacramento KingsUtah Jazz
113​
119​
11/2/2021​
New Orleans PelicansPhoenix Suns
100​
112​
11/2/2021​
Houston RocketsLos Angeles Lakers
117​
119​
11/3/2021​
Portland Trail BlazersCleveland Cavaliers
104​
107​
11/3/2021​
New York KnicksIndiana Pacers
98​
111​
11/3/2021​
Boston CelticsOrlando Magic
92​
79​
11/3/2021​
Chicago BullsPhiladelphia 76ers
98​
103​
11/3/2021​
Toronto RaptorsWashington Wizards
109​
100​
11/3/2021​
Atlanta HawksBrooklyn Nets
108​
117​
11/3/2021​
Denver NuggetsMemphis Grizzlies
106​
108​
11/3/2021​
LA ClippersMinnesota Timberwolves
126​
115​
11/3/2021​
Dallas MavericksSan Antonio Spurs
109​
108​
11/3/2021​
Charlotte HornetsGolden State Warriors
92​
114​
11/3/2021​
New Orleans PelicansSacramento Kings
99​
112​
11/4/2021​
Philadelphia 76ersDetroit Pistons
109​
98​
11/4/2021​
Utah JazzAtlanta Hawks
116​
98​
11/4/2021​
Boston CelticsMiami Heat
95​
78​
11/4/2021​
Houston RocketsPhoenix Suns
111​
123​
11/4/2021​
Oklahoma City ThunderLos Angeles Lakers
107​
104​
11/5/2021​
Brooklyn NetsDetroit Pistons
96​
90​
11/5/2021​
San Antonio SpursOrlando Magic
102​
89​
11/5/2021​
Memphis GrizzliesWashington Wizards
87​
115​
11/5/2021​
New York KnicksMilwaukee Bucks
113​
98​
11/5/2021​
Cleveland CavaliersToronto Raptors
102​
101​
11/5/2021​
LA ClippersMinnesota Timberwolves
104​
84​
11/5/2021​
New Orleans PelicansGolden State Warriors
85​
126​
11/5/2021​
Indiana PacersPortland Trail Blazers
106​
110​
11/5/2021​
Charlotte HornetsSacramento Kings
110​
140​
11/6/2021​
Houston RocketsDenver Nuggets
94​
95​
11/6/2021​
Utah JazzMiami Heat
115​
118​
11/6/2021​
Philadelphia 76ersChicago Bulls
114​
105​
11/6/2021​
Boston CelticsDallas Mavericks
104​
107​
11/6/2021​
Atlanta HawksPhoenix Suns
117​
121​
11/6/2021​
Los Angeles LakersPortland Trail Blazers
90​
105​
11/7/2021​
Brooklyn NetsToronto Raptors
116​
103​
11/7/2021​
Cleveland CavaliersNew York Knicks
126​
109​
11/7/2021​
Utah JazzOrlando Magic
100​
107​
11/7/2021​
Indiana PacersSacramento Kings
94​
91​
11/7/2021​
Milwaukee BucksWashington Wizards
94​
101​
11/7/2021​
San Antonio SpursOklahoma City Thunder
94​
99​
11/7/2021​
Houston RocketsGolden State Warriors
107​
120​
11/7/2021​
Charlotte HornetsLA Clippers
106​
120​
11/8/2021​
New York KnicksPhiladelphia 76ers
103​
96​
11/8/2021​
Brooklyn NetsChicago Bulls
95​
118​
11/8/2021​
Minnesota TimberwolvesMemphis Grizzlies
118​
125​
11/8/2021​
New Orleans PelicansDallas Mavericks
92​
108​
11/8/2021​
Miami HeatDenver Nuggets
96​
113​
11/8/2021​
Atlanta HawksGolden State Warriors
113​
127​
11/8/2021​
Phoenix SunsSacramento Kings
109​
104​
11/8/2021​
Charlotte HornetsLos Angeles Lakers
123​
126​
11/9/2021​
Milwaukee BucksPhiladelphia 76ers
118​
109​
11/9/2021​
Atlanta HawksUtah Jazz
98​
110​
11/9/2021​
Portland Trail BlazersLA Clippers
109​
117​
11/10/2021​
Washington WizardsCleveland Cavaliers
97​
94​
11/10/2021​
Brooklyn NetsOrlando Magic
123​
90​
11/10/2021​
Toronto RaptorsBoston Celtics
88​
104​
11/10/2021​
Detroit PistonsHouston Rockets
112​
104​
11/10/2021​
Milwaukee BucksNew York Knicks
112​
100​
11/10/2021​
Dallas MavericksChicago Bulls
107​
117​
11/10/2021​
Charlotte HornetsMemphis Grizzlies
118​
108​
11/10/2021​
Oklahoma City ThunderNew Orleans Pelicans
108​
100​
11/10/2021​
Sacramento KingsSan Antonio Spurs
117​
136​
11/10/2021​
Indiana PacersDenver Nuggets
98​
101​
11/10/2021​
Portland Trail BlazersPhoenix Suns
109​
119​
11/10/2021​
Minnesota TimberwolvesGolden State Warriors
110​
123​
11/10/2021​
Miami HeatLos Angeles Lakers
117​
120​
11/11/2021​
Toronto RaptorsPhiladelphia 76ers
115​
109​
11/11/2021​
Indiana PacersUtah Jazz
111​
100​
11/11/2021​
Miami HeatLA Clippers
109​
112​
11/12/2021​
New York KnicksCharlotte Hornets
96​
104​
11/12/2021​
Milwaukee BucksBoston Celtics
113​
122​
11/12/2021​
Detroit PistonsCleveland Cavaliers
78​
98​
11/12/2021​
Portland Trail BlazersHouston Rockets
104​
92​
11/12/2021​
Phoenix SunsMemphis Grizzlies
119​
94​
11/12/2021​
Brooklyn NetsNew Orleans Pelicans
120​
112​
11/12/2021​
Sacramento KingsOklahoma City Thunder
103​
105​
11/12/2021​
Dallas MavericksSan Antonio Spurs
123​
109​
11/12/2021​
Atlanta HawksDenver Nuggets
96​
105​
11/12/2021​
Chicago BullsGolden State Warriors
93​
119​
11/12/2021​
Minnesota TimberwolvesLos Angeles Lakers
107​
83​
11/13/2021​
Miami HeatUtah Jazz
111​
105​
11/13/2021​
Philadelphia 76ersIndiana Pacers
113​
118​
11/13/2021​
Memphis GrizzliesNew Orleans Pelicans
101​
112​
11/13/2021​
Washington WizardsOrlando Magic
104​
92​
11/13/2021​
Detroit PistonsToronto Raptors
127​
121​
11/13/2021​
Boston CelticsCleveland Cavaliers
89​
91​
11/13/2021​
Minnesota TimberwolvesLA Clippers
102​
129​
11/14/2021​
San Antonio SpursLos Angeles Lakers
106​
114​
11/14/2021​
Milwaukee BucksAtlanta Hawks
100​
120​
11/14/2021​
Golden State WarriorsCharlotte Hornets
102​
106​
11/14/2021​
Phoenix SunsHouston Rockets
115​
89​
11/14/2021​
Brooklyn NetsOklahoma City Thunder
120​
96​
11/14/2021​
Portland Trail BlazersDenver Nuggets
95​
124​
11/14/2021​
Chicago BullsLA Clippers
100​
90​
11/15/2021​
Boston CelticsCleveland Cavaliers
98​
92​
11/15/2021​
Sacramento KingsDetroit Pistons
129​
107​
11/15/2021​
New Orleans PelicansWashington Wizards
100​
105​
11/15/2021​
Orlando MagicAtlanta Hawks
111​
129​
11/15/2021​
Indiana PacersNew York Knicks
84​
92​
11/15/2021​
Denver NuggetsDallas Mavericks
101​
111​
11/15/2021​
Houston RocketsMemphis Grizzlies
102​
136​
11/15/2021​
Phoenix SunsMinnesota Timberwolves
99​
96​
11/15/2021​
Miami HeatOklahoma City Thunder
103​
90​
11/15/2021​
Toronto RaptorsPortland Trail Blazers
113​
118​
11/15/2021​
Chicago BullsLos Angeles Lakers
121​
103​
11/16/2021​
Golden State WarriorsBrooklyn Nets
117​
99​
11/16/2021​
Philadelphia 76ersUtah Jazz
85​
120​
11/16/2021​
San Antonio SpursLA Clippers
92​
106​
11/17/2021​
Washington WizardsCharlotte Hornets
87​
97​
11/17/2021​
Indiana PacersDetroit Pistons
89​
97​
11/17/2021​
Boston CelticsAtlanta Hawks
99​
110​
11/17/2021​
Cleveland CavaliersBrooklyn Nets
99​
109​
11/17/2021​
New Orleans PelicansMiami Heat
98​
113​
11/17/2021​
Los Angeles LakersMilwaukee Bucks
102​
109​
11/17/2021​
Orlando MagicNew York Knicks
104​
98​
11/17/2021​
Sacramento KingsMinnesota Timberwolves
97​
107​
11/17/2021​
Houston RocketsOklahoma City Thunder
89​
101​
11/17/2021​
Dallas MavericksPhoenix Suns
98​
105​
11/17/2021​
Chicago BullsPortland Trail Blazers
107​
112​
11/18/2021​
Golden State WarriorsCleveland Cavaliers
104​
89​
11/18/2021​
Washington WizardsMiami Heat
97​
112​
11/18/2021​
LA ClippersMemphis Grizzlies
108​
120​
11/18/2021​
San Antonio SpursMinnesota Timberwolves
90​
115​
11/18/2021​
Philadelphia 76ersDenver Nuggets
103​
89​
11/18/2021​
Toronto RaptorsUtah Jazz
103​
119​
11/19/2021​
Indiana PacersCharlotte Hornets
118​
121​
11/19/2021​
Golden State WarriorsDetroit Pistons
105​
102​
11/19/2021​
Los Angeles LakersBoston Celtics
108​
130​
11/19/2021​
Orlando MagicBrooklyn Nets
113​
115​
11/19/2021​
Oklahoma City ThunderMilwaukee Bucks
89​
96​
11/19/2021​
LA ClippersNew Orleans Pelicans
81​
94​
11/19/2021​
Chicago BullsDenver Nuggets
114​
108​
11/19/2021​
Dallas MavericksPhoenix Suns
104​
112​
11/19/2021​
Toronto RaptorsSacramento Kings
108​
89​
11/20/2021​
Houston RocketsNew York Knicks
99​
106​
11/20/2021​
New Orleans PelicansIndiana Pacers
94​
111​
11/20/2021​
Miami HeatWashington Wizards
100​
103​
11/20/2021​
Charlotte HornetsAtlanta Hawks
105​
115​
11/20/2021​
Oklahoma City ThunderBoston Celtics
105​
111​
11/20/2021​
Orlando MagicMilwaukee Bucks
108​
117​
11/20/2021​
Memphis GrizzliesMinnesota Timberwolves
95​
138​
11/20/2021​
Philadelphia 76ersPortland Trail Blazers
111​
118​
11/20/2021​
Utah JazzSacramento Kings
123​
105​
11/21/2021​
Dallas MavericksLA Clippers
91​
97​
11/21/2021​
Los Angeles LakersDetroit Pistons
121​
116​
11/21/2021​
New York KnicksChicago Bulls
103​
109​
11/21/2021​
Denver NuggetsPhoenix Suns
97​
126​
11/21/2021​
Toronto RaptorsGolden State Warriors
104​
119​
11/22/2021​
Brooklyn NetsCleveland Cavaliers
117​
112​
11/22/2021​
Charlotte HornetsWashington Wizards
109​
103​
11/22/2021​
Oklahoma City ThunderAtlanta Hawks
101​
113​
11/22/2021​
Houston RocketsBoston Celtics
90​
108​
11/22/2021​
Indiana PacersChicago Bulls
109​
77​
11/22/2021​
Orlando MagicMilwaukee Bucks
92​
123​
11/22/2021​
Minnesota TimberwolvesNew Orleans Pelicans
110​
96​
11/22/2021​
Phoenix SunsSan Antonio Spurs
115​
111​
11/22/2021​
Memphis GrizzliesUtah Jazz
119​
118​
11/22/2021​
Philadelphia 76ersSacramento Kings
102​
94​
11/23/2021​
Miami HeatDetroit Pistons
100​
92​
11/23/2021​
Los Angeles LakersNew York Knicks
100​
106​
11/23/2021​
Denver NuggetsPortland Trail Blazers
100​
119​
11/23/2021​
Dallas MavericksLA Clippers
112​
104​
11/24/2021​
Phoenix SunsCleveland Cavaliers
120​
115​
11/24/2021​
Los Angeles LakersIndiana Pacers
124​
116​
11/24/2021​
Charlotte HornetsOrlando Magic
106​
99​
11/24/2021​
Brooklyn NetsBoston Celtics
123​
104​
11/24/2021​
Chicago BullsHouston Rockets
113​
118​
11/24/2021​
Toronto RaptorsMemphis Grizzlies
126​
113​
11/24/2021​
Detroit PistonsMilwaukee Bucks
93​
114​
11/24/2021​
Miami HeatMinnesota Timberwolves
101​
113​
11/24/2021​
Washington WizardsNew Orleans Pelicans
102​
127​
11/24/2021​
Utah JazzOklahoma City Thunder
110​
104​
11/24/2021​
Atlanta HawksSan Antonio Spurs
124​
106​
11/24/2021​
Philadelphia 76ersGolden State Warriors
96​
116​
11/24/2021​
Portland Trail BlazersSacramento Kings
121​
125​
11/26/2021​
Detroit PistonsLA Clippers
96​
107​
11/26/2021​
Minnesota TimberwolvesCharlotte Hornets
115​
133​
11/26/2021​
Phoenix SunsNew York Knicks
118​
97​
11/26/2021​
Chicago BullsOrlando Magic
123​
88​
11/26/2021​
Toronto RaptorsIndiana Pacers
97​
114​
11/26/2021​
Atlanta HawksMemphis Grizzlies
132​
100​
11/26/2021​
Washington WizardsOklahoma City Thunder
101​
99​
11/26/2021​
Boston CelticsSan Antonio Spurs
88​
96​
11/26/2021​
Milwaukee BucksDenver Nuggets
120​
109​
11/26/2021​
New Orleans PelicansUtah Jazz
98​
97​
11/26/2021​
Portland Trail BlazersGolden State Warriors
103​
118​
11/26/2021​
Sacramento KingsLos Angeles Lakers
141​
137​
11/27/2021​
Minnesota TimberwolvesPhiladelphia 76ers
121​
120​
11/27/2021​
New York KnicksAtlanta Hawks
99​
90​
11/27/2021​
Phoenix SunsBrooklyn Nets
113​
107​
11/27/2021​
Miami HeatChicago Bulls
107​
104​
11/27/2021​
Orlando MagicCleveland Cavaliers
92​
105​
11/27/2021​
Charlotte HornetsHouston Rockets
143​
146​
11/27/2021​
Washington WizardsDallas Mavericks
120​
114​
11/27/2021​
New Orleans PelicansUtah Jazz
105​
127​
11/28/2021​
Golden State WarriorsLA Clippers
105​
90​
11/28/2021​
Milwaukee BucksIndiana Pacers
118​
100​
11/28/2021​
Sacramento KingsMemphis Grizzlies
101​
128​
11/28/2021​
Boston CelticsToronto Raptors
109​
97​
11/28/2021​
Detroit PistonsLos Angeles Lakers
106​
110​
11/29/2021​
Orlando MagicPhiladelphia 76ers
96​
101​
11/29/2021​
Denver NuggetsMiami Heat
120​
111​
11/29/2021​
Charlotte HornetsChicago Bulls
119​
133​
11/29/2021​
Oklahoma City ThunderHouston Rockets
89​
102​
11/29/2021​
Indiana PacersMinnesota Timberwolves
98​
100​
11/29/2021​
Cleveland CavaliersDallas Mavericks
114​
96​
11/29/2021​
Washington WizardsSan Antonio Spurs
99​
116​


APF SDAPA SDHPF SDHPA SDOverall PF SDOverall PA SD
Atlanta Hawks
12.4​
12.0​
12.0​
13.1​
Boston Celtics
16.2​
15.8​
12.2​
12.5​
Brooklyn Nets
10.9​
9.6​
9.3​
9.7​
Charlotte Hornets
11.5​
12.9​
12.3​
13.4​
Chicago Bulls
12.1​
10.0​
14.2​
12.4​
Cleveland Cavaliers
11.1​
11.5​
12.5​
11.7​
Dallas Mavericks
15.5​
9.4​
8.4​
9.8​
Denver Nuggets
12.7​
10.7​
9.6​
12.1​
Detroit Pistons
12.2​
12.0​
10.9​
11.8​
Golden State Warriors
10.1​
8.1​
10.2​
9.6​
Houston Rockets
11.9​
11.2​
13.9​
13.8​
Indiana Pacers
11.6​
13.5​
9.2​
10.3​
LA Clippers
11.7​
13.1​
11.1​
12.2​
Los Angeles Lakers
11.9​
10.3​
13.0​
12.3​
Memphis Grizzlies
11.7​
11.3​
14.0​
13.0​
Miami Heat
10.3​
8.7​
14.9​
9.9​
Milwaukee Bucks
11.1​
10.4​
12.6​
9.2​
Minnesota Timberwolves
10.4​
12.1​
12.1​
12.8​
New Orleans Pelicans
9.0​
11.2​
9.1​
13.1​
New York Knicks
12.6​
10.7​
9.4​
13.3​
Oklahoma City Thunder
11.0​
12.7​
9.2​
11.8​
Orlando Magic
10.2​
12.0​
9.8​
11.2​
Philadelphia 76ers
10.2​
11.0​
10.6​
8.9​
Phoenix Suns
9.7​
11.6​
9.0​
8.9​
Portland Trail Blazers
8.1​
11.6​
11.4​
13.5​
Sacramento Kings
12.8​
10.0​
14.3​
9.4​
San Antonio Spurs
11.7​
12.7​
11.2​
12.1​
Toronto Raptors
10.8​
15.2​
12.2​
8.6​
Utah Jazz
8.2​
9.5​
11.3​
11.1​
Washington Wizards
10.2​
11.4​
10.2​
11.3​
 

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
Use the filter function inside your function to only get the rows you need! I realise this is not the most detailed answer - but I’m sure you’ll see how to use it by looking at the help…
 
Upvote 0
Use the filter function inside your function to only get the rows you need! I realise this is not the most detailed answer - but I’m sure you’ll see how to use it by looking at the help…
Can't get it to work for what I want.
 
Upvote 0

Forum statistics

Threads
1,223,227
Messages
6,170,848
Members
452,361
Latest member
d3ad3y3

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