Thread: Formula Problem
View Single Post
  #1   Report Post  
the-jackal the-jackal is offline
Junior Member
  
Location: South Woodham Ferrers, Essex
Posts: 19
Default 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
Reply With QuoteReply With Quote