Count numbers in column based on text

[paulsolar]

Hi All

I've seen this before but am unable to find the function to do what I require. let me explain.

In Column B, I have the number of sales a salesman has made to a customer

in Column D, I have the corresponding salesman,s name

in Column K, I have a list of salesmen

i'd like to total all the sales per salesman to all their customers (from column B) next to the salesman in column L

An example would be, John has 5 customers in column B with his name next to these in column D.

each customer has bought 5 items, therefore if john was in K1 then L1 would be 25

Sorry it's such a terrible explanation.

Any help would be appreciated, i know the formula needs to be in L1 but cant for the life of me think what it should be

Cheers

Paul

 

[philwojo]

Busy right now, but this sounds like a good case for a COUNTIFS formula, try and work through it and see if you can make it work. I'm sure there are other was as well.

Also, if you post some sample data with the results you expect it is always helpful.

 

[paulsolar]

Hi, I've been looking at Sumif's and cant seem to get it to work

I'll try countifs

 

[paulsolar]

Got it

=SUM(SUMIFS($B$3:$B$386,$D$3:$D$386,K3))

all i need to do know is work out how to do this in VBA and I'm sorted

 

[philwojo]

I don't think you need to wrap the SUMFIS with the sum, that is redundant, but not hurting anything.

I came up with this also, and I agree SUMIFS was needed not COUNTIFS, sorry about that.

=SUMIFS($B:$B,$D:$D,K$1)

As for VBA, that is beyond my knowledge, but there are a lot of people on here I"m sure can help with that.

 

[paulsolar]

Thanks for your help, i thought i was going mad, you helped me look at it again which was what was required.