Hi all. Formula below is, to my eyes correct in the sense it will evaluate data and count anything it finds, greater than -5.0% and +5.0%. =COUNTIFS(B21:B29,"MIN",U21:U29,"<-0.05",U21:U29,">0.05") Even though I have 4 values that meet the criteria, no results, or errors, are returned. Should I quit now? Any help is trully appreciated. Regards, Albert
This question generated 19 answers. To proceed to the answers, click here.
This thread is current as of October 30, 2014.