I'm sure it's simple!!!

[Fletchmeister]

I require a formula that will reurn a count value between a range of numbers.

i.e. 8-14, if I had a column with 9,11 & 13 in seperate cells. I need a formula that will return the answer as 3. =>8 & <=14.

Can someone please help???

 

[Richie(UK)]

EDIT: Oops - misread the question! Go with Mudface's suggestion below. :wink:

Hi F,

Welcome to the board :D

You could probably modify something like this to suit your needs:

Book1
	A	B	C	D
1	9	Minimumrangevalueis9andmaximumrangevalueis13
2	11
3	13
Sheet1

HTH

 

[Mudface]

A couple of ways, the first uses DCount with the criteria in the first two rows, the second uses an array formula, which needs to be entered with Control-Shift and Enter:-

Book1
	A	B	C	D
1	Data	Data
2	>=8	<=14
3
4	Data	UsingDCount	UsingArrayFormula
5	15	2	2
6	11
7	13
Sheet1

 

[GlennUK]

I think you mean you want to count how many values lie in the range 8-14, and I would use a couple of countif functions in a formula like this ...

=COUNTIF(A1:A10,"<=14")-COUNTIF(A1:A10,"<8")

i.e. count how many are less than or equal 14, then subtract those that are less than 8. Alter the ranges to suit you worksheet.


Cheers, Glenn.

 

[Aladin Akyurek]

Let C2 house 8 and D2 14. Given that A2:A10 is the range of interest, try one of...

=COUNTIF(A2:A10,">="&C2)-COUNTIF(A2:A10,">"&D2)

=SUMPRODUCT((A2:A10>=C2)*(A2:A10<=D2))