COUNT function does not count values beginning with text

**PeteABC123** · 11-15-2013, 05:30 PM

Have this formula to evaluate a range:

=COUNT(A2:A1000)

If some of the values in COL A begin with a letter (not a number), it will ignore that item in the COUNT result.

Is there a formula that will correctly return the number of non blank cells? COL A can contain either numbers, text, or combinations of letters & numbers in the cells value.

TIA for any ideas on this.

Pete

**jonboy6257** · 11-15-2013, 05:35 PM

Yes, =COUNTA() should count all non empty cells

**PeteABC123** · 11-15-2013, 05:57 PM

Thank you jonboy6257. I'd tried the COUNTA.

Unfortunately, the range it's evaluating contain formulas, and many contain a "".

COUNTA seems to interpret that as a non-empty cell, even though it appears blank.

Need to count the number of values that have actually been returned.

Thanks for ideas.

Pete

**azumi** · 11-15-2013, 06:30 PM

=COUNTIF(A1:A6,"<>"&"")

Azumi

**PeteABC123** · 11-15-2013, 06:38 PM

Many thanks azumi.

COUNT function does not count values beginning with text

LinkBack

Thread Tools

Rate This Thread

Display

COUNT function does not count values beginning with text

Re: COUNT function does not count values beginning with text

Re: COUNT function does not count values beginning with text

Re: COUNT function does not count values beginning with text

Re: COUNT function does not count values beginning with text

Thread Information

Users Browsing this Thread

Similar Threads

Count Number Of lines in text files and append values to beginning of file

[SOLVED] Count Intervals of Filtered TEXT values in Column and Return Count across a Row

Count Intervals of Filtered TEXT values in Column and Return Count across a Row

[SOLVED] Count Intervals of Filtered TEXT values in Column and Return Count across a Row

[SOLVED] Count Intervals of Filtered TEXT values in Column and Return Count across a Row

Bookmarks

Bookmarks

Posting Permissions