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

#### POWERBOOK

##### New Member
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

### Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.
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")

Copy H2 down to H3:H5

Excel 2012
ABCDEFGH
1Count
2ExistingANewA1
3NewBNewB2
4NewBExistingA1
5NewAExistingB2
6ExistingB
7ExistingB
8
Sheet1
Cell Formulas
RangeFormula
H2=SUMPRODUCT((\$A\$2:\$A\$7=F2)*(\$B\$2:\$B\$7=G2))

Try

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

Just adapt it for the other scenario's.

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

Change for each set of criteria

Replies
2
Views
335
Replies
1
Views
3K
Replies
5
Views
536
Replies
3
Views
488
Replies
1
Views
872

Threads
1,203,464
Messages
6,055,578
Members
444,800
Latest member
KarenTheManager

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back