Drop the double quotes around the numbers:
=IF(AND(G12="Fail"),1,0)

Otherwise, those values will be treated as text.

the-jackal wrote:

Hope someone can help,

I am using this formula =IF(AND(G12="Fail"),"1","0") and need to add up
all the column but I keep getting 0 even though there are 14 1’s in the
column.

Thanks in advance

Carl

--
the-jackal

--

Dave Peterson