Thread: Formula problem
View Single Post
  #1   Report Post  
Mike
 
Posts: n/a
Default Formula problem

can anyone tell me what is wrong with this?

=SUM(IF(K2:K3790 = "Tx",IF(O2:O3790 ="Yes",1,0),0))

Worked fine yesterday, counted the number of times K=TX and O = yes