Count if with multiple condition.

[avisoft20]

Dear Sir, I want to count state wise status of billed or not billed,i am applying countifs but its not working. Example SHEET:1 State Status ASSAM BILLED ASSAM NOT BILLED ASSAM BILLED CHANDIGARH BILLED CHANDIGARH NOT BILLED <tbody> </tbody>

<tbody>
</tbody>

ANS:

	COUNT
STATE	BILLED	NOT BILLED
ASSAM	2	1
CHANDIGARH	1	1

<tbody>
</tbody>

thank you
Avinash kr singh

 

[FormR]

Hi, not sure what you tried exactly but COUNTIFS() should be what you need..:

Excel 2013/2016
	A	B	C
1	STATE	BILLED	NOT BILLED
2	ASSAM	2	1
3	CHANDIGARH	1	1
Sheet2

Cell Formulas
Range	Formula
B2	=COUNTIFS(Sheet1!$A:$A,$A2,Sheet1!$B:$B,B$1)

Excel 2013/2016
	A	B
1	State	Status
2	ASSAM	BILLED
3	ASSAM	NOT BILLED
4	ASSAM	BILLED
5	CHANDIGARH	BILLED
6	CHANDIGARH	NOT BILLED
Sheet1