how many entries in column 1 minus those in column 2
repeat for range range 2, range 3 , range 4
I'm trying to duplicate a form....so only so many rows will fit on each "page"
The rows =the range
i.e. (Count(A4:A24))-(Count(B4:B24))
and do the same thing 4 different times for the different "pages" then give me the total.
because the cells contain numbers combined with text, the above formula won't work