"TEXT" numbers - count problem

  • Thread starter Thread starter Len Dolby
  • Start date Start date
L

Len Dolby

Team position 1 is entered as '1 (i.e 1 preceded by a single quote) and
there's more than one numeric team position

When I try to "count" the number of occurrences of " '1 "in a data row
which includes both
text '1 and numeric 1 (score), Excel treats all cells as numeric.

How to count " '1 " and Numeric 1 in a data row, please ? Example -

A1 A2 A3 A4
'1 '1 1 COUNTIF(A1..A4,1 yields 3, (correct answer 1) and
I've yet to establish correct syntax
for counting "'1 " ( correct answer 2).

HELP please !
 
=SUMPRODUCT(ISTEXT(A1:A5)*(A1:A5="1"))

=SUMPRODUCT(ISNumber(A1:A5)*(A1:A5=1))

worked for me.
 
Back
Top