Spreadsheet: 714240d1611149752-averageif-within-a-subtotal-forum-example-3
Sheet: Sheet1

 | # of Outlets | Green | Amber | Red | Dwell Time Last Year | Dwell Time This Year
01. Bar
02. Bar & Kitchen
03. Events Venue
04. Holiday Park
05. Hotel
06. [NAME]
07. Local
08. [NAME]
09. Restaurant
10. Sports/Social Club
11. Leisure/Health Club
12. Unknown
Total
 | % Open
Outlet Type | Outlet Quality | Outlet Open? | Owner | Outdoor Space? | Dwell Time Last Year | Dwell Time This Year
01. Bar | P | GREEN | Company A | Y | 123 | 150
02. Bar & Kitchen | P | AMBER | Company B | N | 124 | 149
03. Events Venue | U | RED | Company C | Y | 125 | 148
04. Holiday Park | P | GREEN | Company A | N | 126 | 147
05. Hotel | P | AMBER | Company B | Y | 127 | 146
06. [NAME] | U | RED | Company C | N | 128 | 145
07. Local | P | GREEN | Company A | Y | 129 | 144
08. [NAME] | V | AMBER | Company B | N | 130 | 143
09. Restaurant | M | RED | Company C | Y | 131 | 142
10. Sports/Social Club | P | GREEN | Company A | N | 132 | 141
11. Leisure/Health Club | U | AMBER | Company B | Y | 133 | 140
12. Unknown | U | RED | Company C | N | 134 | 139
01. Bar | P | GREEN | Company A | Y | 135 | 138
02. Bar & Kitchen | P | AMBER | Company B | N | 136 | 137
03. Events Venue | V | RED | Company C | Y | 137 | 136
04. Holiday Park | U | GREEN | Company A | N | 138 | 135
05. Hotel | P | AMBER | Company B | Y | 139 | 134
06. [NAME] | P | RED | Company C | N | 140 | 133
07. Local | M | GREEN | Company A | Y | 141 | 132
08. [NAME] | M | AMBER | Company B | N | 142 | 131
09. Restaurant | P | RED | Company C | Y | 143 | 130
10. Sports/Social Club | M | GREEN | Company A | N | 144 | 129
11. Leisure/Health Club | U | AMBER | Company B | Y | 145 | 128
12. Unknown | P | RED | Company C | N | 146 | 127
01. Bar | M | GREEN | Company A | Y | 147 | 126
02. Bar & Kitchen | P | AMBER | Company B | N | 148 | 125
03. Events Venue | M | RED | Company C | Y | 149 | 124
04. Holiday Park | P | GREEN | Company A | N | 150 | 123
05. Hotel | V | AMBER | Company B | Y | 151 | 122
06. [NAME] | M | RED | Company C | N | 152 | 121
07. Local | V | GREEN | Company A | Y | 153 | 120
08. [NAME] | M | AMBER | Company B | N | 154 | 119
09. Restaurant | P | RED | Company C | Y | 155 | 118
10. Sports/Social Club | M | GREEN | Company A | N | 156 | 117
11. Leisure/Health Club | V | AMBER | Company B | Y | 157 | 116
12. Unknown | P | RED | Company C | N | 158 | 115
01. Bar | P | GREEN | Company A | Y | 159 | 114
02. Bar & Kitchen | P | AMBER | Company B | N | 160 | 113
03. Events Venue | M | RED | Company C | Y | 161 | 112
04. Holiday Park | P | GREEN | Company A | N | 162 | 111
05. Hotel | M | AMBER | Company B | Y | 163 | 110
06. [NAME] | P | RED | Company C | N | 164 | 109
07. Local | P | GREEN | Company A | Y | 165 | 108
08. [NAME] | P | AMBER | Company B | N | 166 | 107
09. Restaurant | P | RED | Company C | Y | 167 | 106
10. Sports/Social Club | P | GREEN | Company A | N | 168 | 105
11. Leisure/Health Club | V | AMBER | Company B | Y | 169 | 104
12. Unknown | U | RED | Company C | N | 170 | 103
01. Bar | P | GREEN | Company A | Y | 171 | 102
02. Bar & Kitchen | P | AMBER | Company B | N | 172 | 101
03. Events Venue | V | RED | Company C | Y | 173 | 100
04. Holiday Park | P | GREEN | Company A | N | 174 | 99
05. Hotel | M | AMBER | Company B | Y | 175 | 98