I think I need to use COUNTIF but I don't know how! Please may I have some help!!!

[POWERBOOK]

Please could I have some help with following data series

A B
Existing A
New B
New B
New A
Existing B
Existing B

I have two columns.
Data in Column A is either 'New' or 'Existing'
Data in Column B is either 'A' or 'B'

I need to do is:
(a) how many instances there are of 'New' that are 'A' type
(b) how many instances there are of 'New' that are 'B' type
(c) how many instances there are of 'Existing' that are 'A' type
(d) how many instances there are of 'Existing' that are 'B' type

Using the above example data, the answers would be:
(a) 1
(b) 2
(c) 1
(d) 2

Thanks for any help. I have been trying for a hour but can't get it to work!

Thanks very much
Sally

 

[bbott]

Welcome to the board.

This counts Existing and A. Adapt the text in red for the other combinations:

=COUNTIFS(A:A,"Existing",B:B,"A")

 

[jim may]

Copy H2 down to H3:H5

Excel 2012
	A	B	C	D	E	F	G	H
1								Count
2	Existing	A				New	A	1
3	New	B				New	B	2
4	New	B				Existing	A	1
5	New	A				Existing	B	2
6	Existing	B
7	Existing	B
8
Sheet1

Cell Formulas
Range	Formula
H2	=SUMPRODUCT(($A$2:$A$7=F2)*($B$2:$B$7=G2))

 

[gaz_chops]

Try

=COUNTIFS(A1:A6,"Existing",B1:B6,"A")

Just adapt it for the other scenario's.

 

[Gandor]

=COUNTIFS(A:A,"Existing",B:B,"A")

Change for each set of criteria