chard to count blank cells when used and not in use.
 

Please help!
I have tried to create a chart were I can have the program count the blank
cells only. The problem is that it worked the first time but then when I
started to move the content around the formula did not work and would not
give me the right number of blank cells. I need a formula that will give the
number of blank cells no matter where and how many times I rearrange the
content around the worksheet. This is the formula I used. thanks

=COUNTIF(C5:C46,"")

column c column d column e
x x
x v v
x x
x v
x x
v x
column c should be (3) blank cells
column d should be (2) blank cells
column e should be (2)blank cells, so on and so on.
--
LilOMS