CATERGORY COUNT REQUIRED

[asksign]

AVAILABLE DATA		REQUIRED ANSWER
Section	Category		Section	0 to 180	181 to 300	301 TO 500	501 TO 700	701 TO 1000	ABOVE 1000
A	0 to 180		A	NEED COUNT HERE
B	181 to 300		B
C	301 TO 500		C
D	501 TO 700		D
E	701 TO 1000		E
F	ABOVE 1000		F
A	301 TO 500
C	501 TO 700
D	701 TO 1000
E	701 TO 1000
F	0 to 180

 

[Saurabhj]

Hi, use countifs formula.

Queries-2.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L
1	Section	Category		Section	0 to 180	181 to 300	301 TO 500	501 TO 700	701 TO 1000	ABOVE 1000
2	A	0 to 180		A	1	0	1	0	0	0
3	B	181 to 300		B	0	1	0	0	0	0
4	C	301 TO 500		C	0	0	1	1	0	0
5	D	501 TO 700		D	0	0	0	1	1	0
6	E	701 TO 1000		E	0	0	0	0	2	0
7	F	ABOVE 1000		F	1	0	0	0	0	1
8	A	301 TO 500
9	C	501 TO 700
10	D	701 TO 1000
11	E	701 TO 1000
12	F	0 to 180
13
14
15
Sheet3

Cell Formulas
Range	Formula
E2:J7	E2	=COUNTIFS($A:$A,$D2,$B:$B,E$1)