# Information From 2 Coluumns

#### AFIORE

##### New Member
I am unsure if this was answered already but I am having a lot of trouble. I am trying to find out if it is possible to count the number of entries in one column if it meets criteria in another comlumn?

Here is my problem: I work for a contractor and I am trying to find out the number of contracts sold(column J) by Mike (Column K). I have tried =COUNTIFS functions but these dont work. I know if I create 4 other columns with IF functions I can get the information but I have to imagine there is another way. Please Help!

### Excel Facts

To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

#### PaulM2009

##### Board Regular
If you are trying to count how many times something occurs you could try =countif(K:K, "Mike")

#### lenze

##### Legend
What kind of entries are in Column "J"

lenze

#### AmyC

##### New Member
The easiest way to do it is with filters, if you just need to look at totals for one person at a time. Do you need to create reports off of it, or is it just for reference?

So filter column K to just show mike, and then use subtotals to add column J.

#### AFIORE

##### New Member
Column J is all dollar amounts. (\$1903.56, \$750.00, \$24,000.00, etc.)

#### PaulM2009

##### Board Regular
Maybe I read it wrong. Are you looking for total number of contracts or total dollar amount of contracts?

#### AFIORE

##### New Member
Maybe this is a little easier, this would be what the spread sheet looks like(roughly):

COLUMN A COLUMN J COLUMN K
NAME SOLD SALESMAN
MR \$15,00.00 MIKE
MR MIKE
MR \$750.00 DAVE
MRS \$820.56 MIKE

What I need is a function that will tell me how many Mike sold (2)

#### AmyC

##### New Member
Filtering still works, and is super simple. Just use a different subtotal function - to count non blanks. Do you need to see how many mike sold at the same time you see how many dave sold, or is it just for reference?

#### PaulM2009

##### Board Regular
I think =countif(K:K, "Mike") will work then. <!-- / message --><!-- sig -->

#### AFIORE

##### New Member
The only problem with the countif(k:k, "mike") is that there are some entries for Mike that do not have an entry in column J.
Its for a closing ratio of how many contracts Mike sold. All of the people he met with will be listed and not all of them were sold, unfortunately.

Replies
10
Views
272
Replies
4
Views
104
Replies
3
Views
107
Replies
13
Views
455
Replies
0
Views
95

1,190,786
Messages
5,982,917
Members
439,807
Latest member
WXM86

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