sconly
07-05-2011, 06:55 AM
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.
I've tried COUNTA but that doesn't work, it still count the cells with empty string in.
Can anyone help?
Thanks.