Hi,

Is it possible to search a spreadsheet and count the numbers that only start
with the number 1? And then also count how many cells it searched in order
to obtain that value?

For Example:
10
2,100
1,500,100
10,150,280
317

Cells with the number 1 = 3
Total cells looked at = 5

Thanks!