CODEWITHSUNDEEP
excelexcel-formula
Carol.Kar
Carol.Kar

Reputation: 5345

Count if value is not blank

I want to count all cells which are NOT(ISBLANK()).

I tried this:

enter image description here

Why does this does not work?

Upvotes: 1

Views: 376

Answers (2)

Jean-François Corbett
Jean-François Corbett

Reputation: 38500

That's not the right syntax for the COUNTIF function. For more, see the documentation.

Instead, you can use this regular formula:

=SUMPRODUCT(--NOT(ISBLANK(A:A)))

or this array formula

=SUM(--NOT(ISBLANK(A:A)))

The latter must be entered as an array formula using Ctrl Shift Enter.

enter image description here

Upvotes: 3

JDunkerley
JDunkerley

Reputation: 12495

You can use:

=COUNTIF(B2:B8,"<>")

Upvotes: 1

Related Questions