Q: Say for example, I want Excel to count how many values there are in between 10 and 20 in the following sample: 5,8,11,12,15,16,18,24,28 How would I write this in the function?
A: Let's say your numbers are in column D, rows 2 thru 10: =COUNTIF(D2:D10,">=10") -COUNTIF(D2:D10,">20") The above is on two separate lines only for viewing purposes....you need to include them as one line...no spaces