Theres multiple ways of doing this but the best would be not to change the
info at all. If you want to do counts on strings then you can use countif.

So you can do =Countif($e$1:$e$6,"SF")

"Greg" wrote:

Hello, I have been searching for two days on the internet and haven't found
anyone attempting this so far.

I would like to find a formula for this:

Cell's E1 through E6, if they match said criteria (ie...specific letters)
than replace those cells info with a "1" if not than replace cells with a
"0".

Thus I can sum my rows with 1's and 0's. Is this possible?

EXAMPLE:
E1
SF
if E1 matches "SF" then replace "SF" with a number value of "1". When I
attempt this, I get a Circle Error.

Thanks in advance.