Equation to count empty cell

[n07cn3]

Please help.

Is there an equation to count how many cell has not been "audit" yet?

The equation would return value "10" for this example.
Please see attach sample data.

Thanks in advance!

how to count empty cell.xlsx

[alansidman]

Try this:

=COUNT(B2:B20)-COUNT(C2:C20)

[n07cn3]

Thanks alansidman

[n07cn3]

Alan,

is there a way to only count column B and column C if there is a value?

the issue i am having is that everyday new data is going to be add on.

thanks!

[krish_dums]

Hi,

If you are using Excel 2007 you have a countblank function predefined that can be used
and if you are using excel 2003 you can use =COUNTIF(range,"")

[krish_dums]

Hi,

If you could provide a sample file i could try and provide a solution to your answer. My email id is krish_dums@live.in

Thanks

[RobertMika]

maybe
COUNTA(B:C)

for non empty cells
or
COUNT(B:C)
for numbers only

[n07cn3]

my data change/grow from day to day.
let said day1 i have 19 values in column B and 9 values in column C. I need an equation to give an answer = 10 (19-9=10).
let said day2 my data change and i have 25 values in column B and 20 values in column C. I need an equation to give an answer = 5 (25-20=5)
day3 ..... so on an so on.

Please see sample data attach above.

thanks!

[RobertMika]

=COUNTIFS($B$2:$B$40,"<>",$C$2:$C$40,"=")
You can change 40 to greater value if you need