G Guest Oct 10, 2007 #1 I need to count the numbers in a range that fall equal to or more than one number and equal to or less than one number
I need to count the numbers in a range that fall equal to or more than one number and equal to or less than one number
T T. Valko Oct 10, 2007 #2 Try it like this: =COUNTIF(A1:A10,">=start_number")-COUNTIF(A1:A10,">stop_number") Start number = 10 Stop number = 20 =COUNTIF(A1:A10,">=10")-COUNTIF(A1:A10,">20") Or, if you use cells to hold the start/stop numbers: B1 = 10 B2 = 20 =COUNTIF(A1:A10,">="&B1)-COUNTIF(A1:A10,">"&B2)
Try it like this: =COUNTIF(A1:A10,">=start_number")-COUNTIF(A1:A10,">stop_number") Start number = 10 Stop number = 20 =COUNTIF(A1:A10,">=10")-COUNTIF(A1:A10,">20") Or, if you use cells to hold the start/stop numbers: B1 = 10 B2 = 20 =COUNTIF(A1:A10,">="&B1)-COUNTIF(A1:A10,">"&B2)
G Guest Oct 10, 2007 #3 =COUNTIF(A2:A37,">.7900")-COUNTIF(A2:A37,"<.7950") This is what I tried and it is coming up with values that are not supposed to be included, there should only be one entry that fits the formula with these numbers.
=COUNTIF(A2:A37,">.7900")-COUNTIF(A2:A37,"<.7950") This is what I tried and it is coming up with values that are not supposed to be included, there should only be one entry that fits the formula with these numbers.
D David Biddulph Oct 10, 2007 #4 Look again at the formula you were given, and correct yours accordingly. Check the difference between >, >=, and <
Look again at the formula you were given, and correct yours accordingly. Check the difference between >, >=, and <
