albertc30
Well-known Member
- Joined
- May 7, 2012
- Messages
- 1,091
- Office Version
- 2019
- Platform
- Windows
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
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