Formula Help With Countif

davidascott
davidascott used Ask the Experts™
on
I have the following formuila in a spreadsheet:

COUNTIF(Bills_New!$M$8:$BQ$20,"<>"&"")

Am I right that it is saying that it will count anythng in the range if the cell is not blank?  I am not sure what <> actually says.  Please explain.
Thanks, David
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2010
Commented:
davidascott,

Yes, that is exactly what the formula is doing.  BTW, the &"" is not needed; remove it, and the formula behaves the same way.

Do be advised that even a cell with a formula that evaluates to a zero-length string will be counted!

That is, the formula is counting all cells that have either a constant or a formula.

Patrick
Most Valuable Expert 2011
Top Expert 2011

Commented:
It counts any cell that has a value other than "".
Most Valuable Expert 2011
Top Expert 2011

Commented:
Correction - any cell other than a blank cell, as you originally thought - it will ignore cells with "" as the result of a formula.

Commented:
You might also consider using COUNTA:

COUNTA(Bills_New!$M$8:$BQ$20)

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial