Countif using multiple criteria

[Dargie30]

Hi I am trying to use a countif based against using the following criteria
where the value of column falls between the bands and then how many people fall within that Band
Band 1 0-4999.99
Band 2 5000-9999.99
etc

and then to find out how many times the numbers 40 42 61 65 within the 2000 records I have.

looking for end result example of 40 42 61 65
0-4999.99 2 10 3 15
5000-9999.99 10 25 6 12

is this possible to do at all ?

 

[Andrew Poulsom]

You can subtract 2 SUMIF's eg:

=SUMIF(A:A,"<10000",B:B)-SUMIF(A:A,"<5000",B:B)

 

[sanrv1f]

May be this

Excel Workbook
	A	B
1	Value	Age
2	2827	40
3	1505	42
4	3465	61
5	3979	42
6	8578	61
7	6564	61
8	5840	61
9	8694	61
10	6801	40
11	5530	42
12	4859	42
13	4808	65
Sheet1

Excel 2007

Excel Workbook
	E	F	G	H	I	J
2	From	To	40	42	60	61
3	0	5000	1	3	0	1
4	5000	10000	1	1	0	4
Sheet1

Excel 2007

Cell Formulas
Range	Formula
G3	=SUMPRODUCT(--($A$2:$A$13>=$E3),--($A$2:$A$13<$F3),--($B$2:$B$13=G$2))

 

[Dargie30]

thanks , you have saved me from manually doing this