Count Criteria

[marej]

I have the following scenario - I need to count items based on multiple criteria. I have put the answer required. Can someone please tell me what the formula would be. Please note this is just a sample. The number of criteria that needs to be counted will vary.

Data Criteria Data to count
contract 1 10
contract 1 20
contract 1 30
contract 1 30
contract 4 10

ANSWER
Data - Criteria Data to count
contract 1 4
contract 4 1

 

[pgc01]

Hi marej

Take a look at the function COUNTIFS().

 

[anandvarma]

try this

Excel Workbook
	A	B	C	D	E
1	contract 1	10		contract 1	4
2	contract 1	20		contract 4	1
3	contract 1	30
4	contract 1	30
5	contract 4	10
Sheet1

 

[bosco_yip]

using anandvarma's table.

Cell E1 formula, copy down :

=COUNTIF(A:A,D1)

Regards

 

[marej]

Hi Thanks

You made me realise I didnt need to use both columns.