Countif or SumProduct?

[rogersj]

I have a bunch of data (text) in D. I want to know how many strings there are... I tried

=COUNTIF(D4:D160,<"")

But can't get it to work. What's the proper formula? Thanks.

 

[Lewiy]

Perhaps:
=COUNTIF(D4:D160,<>"")

 

[daniels012]

Just to be clear, what do you mean by "how many strings"?

This will help achieve your desired result.

Michael

 

[QuietRiot]

can't you also throw a ISTEXT() in there

 

[rogersj]

I have items listed all throughout D4-D160, I want to count if there is anything in each cell.

 

[Lewiy]

In that case:
=COUNTA(D4:D160)