Count non empty cells

[sconly]

How do i count the number of cells - in a row - that aren't blank (or don't contain an empty string, i.e. "")?

I've tried COUNTA but that doesn't work, it still count the cells with empty string in.

Can anyone help?

Thanks.

[Kenneth Hobs]

It is working as designed. "" is a value. Try:
=COLUMNS(A1:E1)-COUNTBLANK(A1:E1)

[sconly]

Awesome.

Thanks Kenneth.

Solved.