Countif Not Null

[Guest]

I have trouble ticket information grouped into categories and I want to count
the instances of each category. For example

A1 A2
Ticket # Description
6528 Technician didn't show on time
5879 Other issue

Countif (A2:A3, "Not Null") This formula returns a zero. Is there a way to
count a cell if it is not null?

 

[Frank Kabel]

Hi
one way:
=SUMPRODUCT(--(A1:A100<>""))

 

[Myrna Larson]

That formula is looking for cells the contain the literal text, Not Null. If
you want to know how many filled cells there are, use =COUNTA(A2:A3).

If you mean something else, please try gain. And, you show A1 and A2 at the
top? Do you really mean columns A and B, i.e. ticket number is in column A and
description in B? That would be a more likely layout.

 

[Alan Beban]

I have trouble ticket information grouped into categories and I want to count
the instances of each category. For example

A1 A2
Ticket # Description
6528 Technician didn't show on time
5879 Other issue

Countif (A2:A3, "Not Null") This formula returns a zero. Is there a way to
count a cell if it is not null?

What do you mean "not null"? Suppose the cell contains the empty string
""; is that cell null or not?

Alan Beban

 

[Myrna Larson]

Or, if the column contains only literals and not formulas returning "", a
simpler formula would be =COUNTA(A1:A100).