Information From 2 Coluumns

[AFIORE]

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!

 

[PaulM2009]

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

 

[lenze]

What kind of entries are in Column "J"

lenze

 

[AmyC]

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]

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

 

[PaulM2009]

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

 

[AFIORE]

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]

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]

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

 

[AFIORE]

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.