I have this formula that i will be doing a paste special (formula) on

=(CELL("row")-CELL("row",B109)-COUNTBLANK(B129:cell("address"))
it should number my rows 1,2,3,4,5,ect.. with my different sized merged cells (hence why i just dont drag the numbers to automatically number my rows, it throws a error "This operation requires the merged cells to be identically sized numbers")

why will it not let me combine the cell call with the COUNTBLANK?

i also know VB and if anyone knows a macro that can help me or a different formula that would be great but this should work.