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

L

Lilme@25

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count max consecutive cells 2
How to count non blank cells with a condition? 1
Need Array Formula for Counting Blank & Non Blank Cells (Multiple Criteria) 3
counting groups of blank cells 3
need help in fine-tuning a formula that removes blank cells in a column range 3
If then formula with multiple cells 2
Concatenating adjacent cells ignoring blanks and adding a delimite 3
CONDITIONAL SUM ("OR") 7

Top