Spreadsheet: 122339d1316745591-running-total-formula-unique-running-total
Sheet: Sheet1

 | Any Data entered cell 15 and above count numbers in blue Cells Only to reach the total in cell F3 example
 |  | Example 1 |  |  |  |  | Example 2 |  |  |  |  | Example 3 |  |  |  |  | Example 4 |  |  |  |  | Example 5 |  |  |  |  | Example 6 |  |  |  |  | Example 7
 | Total: |  | 5587 |  |  | Total: |  | 5069 |  |  | Total: |  | 4645 |  |  | Total: |  | 4256 |  |  | Total: |  | 3997 |  |  | Total: |  | 3533 |  |  | Total: |  | 4016
 | 12 |  |  |  |  | 12 |  |  |  |  | 12 |  |  |  |  | 12 |  |  |  |  | 12 |  |  |  |  | 12 |  |  |  |  | 12
 | 11 |  |  |  |  | 11 |  |  |  |  | 11 |  |  |  |  | 11 |  |  |  |  | 11 |  |  |  |  | 11 |  |  |  |  | 11
 | 10 |  |  |  |  | 10 |  |  |  |  | 10 |  |  |  |  | 10 |  |  |  |  | 10 |  |  |  |  | 10 |  |  |  |  | 10
 | 9 |  |  |  |  | 9 |  |  |  |  | 9 |  |  |  |  | 9 |  |  |  |  | 9 |  |  |  |  | 9 |  |  |  |  | 9
 | 8 |  |  |  |  | 8 |  |  |  |  | 8 |  |  |  |  | 8 |  |  |  |  | 8 |  |  |  |  | 8 |  |  |  |  | 8
 | 7 |  |  |  |  | 7 |  |  |  |  | 7 |  |  |  |  | 7 |  |  |  |  | 7 |  |  |  |  | 7 |  |  |  |  | 7 | 158 | 125 | 200
 | 6 |  |  |  |  | 6 |  |  |  |  | 6 |  |  |  |  | 6 |  |  |  |  | 6 |  |  |  |  | 6 | 147 | 159 | 258 |  | 6 | 147 | 159 | 258
 | 5 |  |  |  |  | 5 |  |  |  |  | 5 |  |  |  |  | 5 |  |  |  |  | 5 | 213 | 213 | 213 |  | 5 | 213 | 213 | 213 |  | 5 | 213 | 213 | 213
 | 4 |  |  |  |  | 4 |  |  |  |  | 4 |  |  |  |  | 4 | 258 | 236 | 247 |  | 4 | 258 | 236 | 247 |  | 4 | 258 | 236 | 247 |  | 4 | 258 | 236 | 247
 | 3 |  |  |  |  | 3 |  |  |  |  | 3 | 125 | 125 | 255 |  | 3 | 125 | 125 | 255 |  | 3 | 125 | 125 | 255 |  | 3 | 125 | 125 | 255 |  | 3 | 125 | 125 | 255
 | 2 |  |  |  |  | 2 | 125 | 123 | 147 |  | 2 | 125 | 123 | 147 |  | 2 | 125 | 123 | 147 |  | 2 | 125 | 123 | 147 |  | 2 | 125 | 123 | 147 |  | 2 | 125 | 123 | 147
 | 1 | 211 | 247 | 231 |  | 1 | 211 | 247 | 231 |  | 1 | 211 | 247 | 231 |  | 1 | 211 | 247 | 231 |  | 1 | 211 | 247 | 231 |  | 1 | 211 | 247 | 231 |  | 1 | 211 | 247 | 231
 | 12 | 125 | 247 | 123 |  | 12 | 125 | 247 | 123 |  | 12 | 125 | 247 | 123 |  | 12 | 125 | 247 | 123 |  | 12 | 125 | 247 | 123 |  | 12 | 125 | 247 | 123 |  | 12 | 125 | 247 | 123
 | 11 | 147 | 125 | 129 |  | 11 | 147 | 125 | 129 |  | 11 | 147 | 125 | 129 |  | 11 | 147 | 125 | 129 |  | 11 | 147 | 125 | 129 |  | 11 | 147 | 125 | 129 |  | 11 | 147 | 125 | 129
 | 10 | 247 | 211 | 198 |  | 10 | 247 | 211 | 198 |  | 10 | 247 | 211 | 198 |  | 10 | 247 | 211 | 198 |  | 10 | 247 | 211 | 198 |  | 10 | 247 | 211 | 198 |  | 10 | 247 | 211 | 198
 | 9 | 191 | 127 | 158 |  | 9 | 191 | 127 | 158 |  | 9 | 191 | 127 | 158 |  | 9 | 191 | 127 | 158 |  | 9 | 191 | 127 | 158 |  | 9 | 191 | 127 | 158 |  | 9 | 191 | 127 | 158
 | 8 | 147 | 159 | 158 |  | 8 | 147 | 159 | 158 |  | 8 | 147 | 159 | 158 |  | 8 | 147 | 159 | 158 |  | 8 | 147 | 159 | 158 |  | 8 | 147 | 159 | 158 |  | 8 | 147 | 159 | 158
 | 7 | 148 | 136 | 266 |  | 7 | 148 | 136 | 266 |  | 7 | 148 | 136 | 266 |  | 7 | 148 | 136 | 266 |  | 7 | 148 | 136 | 266 |  | 7 | 148 | 136 | 266 |  | 7 | 148 | 136 | 266
 | 6 | 147 | 198 | 188 |  | 6 | 147 | 198 | 188 |  | 6 | 147 | 198 | 188 |  | 6 | 147 | 198 | 188 |  | 6 | 147 | 198 | 188 |  | 6 | 147 | 198 | 188 |  | 6 | 147 | 198 | 188
 | 5 | 154 | 177 | 166 |  | 5 | 154 | 177 | 166 |  | 5 | 154 | 177 | 166 |  | 5 | 154 | 177 | 166 |  | 5 | 154 | 177 | 166 |  | 5 | 154 | 177 | 166 |  | 5 | 154 | 177 | 166
 | 4 | 147 | 158 | 169 |  | 4 | 147 | 158 | 169 |  | 4 | 147 | 158 | 169 |  | 4 | 147 | 158 | 169 |  | 4 | 147 | 158 | 169 |  | 4 | 147 | 158 | 169 |  | 4 | 147 | 158 | 169
 | 3 | 136 | 158 | 159 |  | 3 | 136 | 158 | 159 |  | 3 | 136 | 158 | 159 |  | 3 | 136 | 158 | 159 |  | 3 | 136 | 158 | 159 |  | 3 | 136 | 158 | 159 |  | 3 | 136 | 158 | 159
 | 2 | 123 | 189 | 137 |  | 2 | 123 | 189 | 137 |  | 2 | 123 | 189 | 137 |  | 2 | 123 | 189 | 137 |  | 2 | 123 | 189 | 137 |  | 2 | 123 | 189 | 137 |  | 2 | 123 | 189 | 137
 | 1 | 128 | 159 | 200 |  | 1 | 128 | 159 | 200 |  | 1 | 128 | 159 | 200 |  | 1 | 128 | 159 | 200 |  | 1 | 128 | 159 | 200 |  | 1 | 128 | 159 | 200 |  | 1 | 128 | 159 | 200