Formula to pick up data from another sheet

[Caveman1964]

Hi,
I am trying to get a cell to countif from another sheet.
I am on sheet 5 and trying to get data from data collection sheet. and if blank it shows nothing.
For some reason, I am just getting a zero. I want to read column L from data collection and count how many of certain customers are there. New customers are added weekly.
Please help if I explained well enough.
Thank you ahead of time.

=IF(ISBLANK('Data Collection'!L7),"",COUNTIFS('Data Collection'!L$7:L7,L7))

 

[GR00007]

I'm assuming 'sheet 5' has a list of customers, say in column A and that you want to count the customers that match on sheet 'Data Collection' in column L. This will return blank for a missing name in column a and count the matching customers on 'Data Collection'.
Place in row 2 of the column you want to show the count, then propagate down the length of the customer list:
=IF(A2="","",COUNTIF('Data Collection'!L:L,A2))

 

[Caveman1964]

That works perfect. Thank You!
Much appreciated.

You wouldn't happen to know how to filter out the top 5? It counts perfect and I want to pull the top 5 out but a customer may be on there 6 times and the count is 6 but in 6 places. I want to pull the name from column L and the number it shows up. and there will be new customers so I can't use the count and have known criteria.......it has to pick up new customers. I am working with that now and may get figured out. only if you have time. Thanks so much for helping already!

 

[Caveman1964]

Bump

 

[GR00007]

There are a number of ways to do what you want, please check this out.

 

[Caveman1964]

There are a number of ways to do what you want, please check this out.

I checked it out! Thank You!