Excel: Countifs not returning any values...


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.


For more resources for Microsoft Excel