Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula Problem
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Formula Problem
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Formula Problem
I'm not sure why you need the AND in there, and you don't need the
double-quotes, as the returned values will be treated as text (and thus sum to zero). Try this =IF(G12="Fail",1,0) and copy down the column as needed. Hope this helps. Pete 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula percentage problem | New Users to Excel | |||
formula problem | New Users to Excel | |||
problem with Array Formula | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |