# Counting occurrences in two seperate columns

#### JCARMICHAEL

##### New Member
I need help with a formula for counting how many occurrences exist in 2 seperate columns. For instance in my spreadsheet in the Column Heading i have a Column for "New/Renewal" (designated by an "N" or an "R"). I also have a seperate column for "Successful/Unsuccessful" which is designated by entering a "S" or a "U".

What i need is a formula that counts how many times times, for instance, both "N" and "S" occur.

### Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"
If your columns were A and B, are the rows were 1 to 11, this formula would work:

Code:
``=SUMPRODUCT((A1:A11="N")*(B1:B11="S"))``

SUMPRODUCT is the formula to use when you would like to use COUNTIF or SUMIF, but have muliple criteria.

Thank you!

Replies
4
Views
118
Replies
5
Views
123
Replies
2
Views
101
Replies
9
Views
360
Replies
1
Views
159

1,196,514
Messages
6,015,649
Members
441,913
Latest member
Lhayden_69

### 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.

### Which adblocker are you using?

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

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