I am trying to count/find the page count. or more like to find how many pages(blankss) are within Y(each Y)..

example:

(Col1) (Col2) (what im trying to get in the nxt col)
1 Y 3
2
3
4 Y 1
5 Y 5
6
7
8
9
10 C 1

Can anyone help me out??