Nov 26 2020 10:51 AM
Hi,
my question is if I have to put into the X criteria a relalatives how can I do it?
For instance:
- E1 cell contains "4"
- The range is a numeric order from 1 upto 100 in the cells between A1 and A100.
- And the COUNTIFS function has to return with the count of numbers that are less than E1 cell's containt.
The solution should be 3 (1, 2 and 3)
How the formular looks out?
Nov 26 2020 11:16 AM
Nov 26 2020 12:04 PM