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.