Excel Count Functions
Of course, you said "in a row". Try this array-entered formula instead...
=SUM(IF(ISNUMBER(SEARCH("a",1:1)),1,IF(ISNUMBER(SE ARCH("b",1:1)),1,IF(ISNUMBER(SEARCH("c"1:1)),1,0)) ))
**Commit this formula using Ctrl+Shift+Enter, not just Enter by itself.
The 1:1 in each part of the formula means Row 1... change them all (there
are 3 of them) to the row you are interested in (for example 4:4 for Row 4).
And, of course, still change the individual "a", "b", and "c" letters to the
letters you want to look for.
--
Rick (MVP - Excel)
"Rick Rothstein" wrote in message
...
Give this array-entered** formula a try...
=SUM(IF(ISNUMBER(SEARCH("a",A1:A100)),1,IF(ISNUMBE R(SEARCH("b",A1:A100)),1,IF(ISNUMBER(SEARCH("c",A1 :A100)),1,0))))
**Commit this formula using Ctrl+Shift+Enter, not just Enter by itself.
Note: Change the "a", "b", and "c" to the letters you want to find (keep
the letters in quotes when you do).
--
Rick (MVP - Excel)
"Gasbag" wrote in message
...
I am trying to count the number of cells in a row that contain one or more
of
three letters?
|