I have a series of numbers in cell B1 thru B26. Is there a way to count the numbers in this range that are >1 and <11 and have this number show up in cell B27?
The count if function will only work with one criteria.
Any suggestions?
Thanks in advance.
Jerry
The count if function will only work with one criteria.
Any suggestions?
Thanks in advance.
Jerry