Hi
first post, so apologies if I make a mistake
I need to count the following
<tbody>
</tbody>
if column title =
P7 2016 -2017
and
Row =
9789802
Then how many values have I got
So the answer would be 2 for P7, 2 for P8 etc.
The full spreadsheet is 244 rows x 1100 columns
I have tried sumproduct, countifs, etc but cannot get them to work
Thanks very much
first post, so apologies if I make a mistake
I need to count the following
Meter | P7 2016 -2017 | P7 2016 -2017 | P7 2016 -2017 | P8 2016 -2017 | P8 2016 -2017 | P9 2016 -2017 | P9 2016 -2017 |
9761600 | 165 | 167 | 165 | 217 | 233 | 207 | 212 |
9763705 | 237 | 220 | 272 | 240 | 267 | 194 | |
9766902 | 254 | 245 | 363 | 376 | 371 | 323 | |
9767107 | 298 | 336 | 412 | 412 | 409 | 399 | |
9773304 | 371 | 355 | 393 | 355 | 399 | 554 | 481 |
9784803 | 416 | 374 | 351 | 365 | 374 | 400 | 344 |
9789802 | 185 | 186 | 179 | 354 | 345 | 258 |
<tbody>
</tbody>
if column title =
P7 2016 -2017
and
Row =
9789802
Then how many values have I got
So the answer would be 2 for P7, 2 for P8 etc.
The full spreadsheet is 244 rows x 1100 columns
I have tried sumproduct, countifs, etc but cannot get them to work
Thanks very much
Last edited by a moderator: