| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
"TEXT" numbers - count problem
=SUMPRODUCT(ISTEXT(A1:A5)*(A1:A5="1"))
=SUMPRODUCT(ISNumber(A1:A5)*(A1:A5=1)) worked for me. -- Regards, Tom Ogilvy "Len Dolby" wrote in message ... 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 ! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Validation ?:Accepting both Numbers AND specific letters("N","n"," | Excel Discussion (Misc queries) | |||
| How can I convert numbers (ex. "4") to text (ex. "four") | Excel Discussion (Misc queries) | |||
| Formating numbers &"Text" to appear as currency &"Text" in formula | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) | |||
Threaded Mode
