Count number of text without duplicates and blank

[Lan Tran]

Hi guys

I have a table like that (you can see the picture or the attached file) and I need to know the total number of visitors of restaurant A. I can use filter but this sample is a small part of a big data I am having now and using filter is not convinient so I ask for formulas.

Thank you

sample.png
sample.xlsx

[NeedForExcel]

In F2

=COUNTIFS($A$2:$A$7,E2,$B$2:$B$7,"<>"&"")

And Drag Down

[Lan Tran]

oh yes

It's so simple but I cant think like that

Thank you a lot. YOU SAVE MY DAY )

[NeedForExcel]

Glad I could help..

[Lan Tran]

In F2

=COUNTIFS($A$2:$A$7,E2,$B$2:$B$7,"<>"&"")

And Drag Down

Hi

I tried your formula but it does not work with all the information. I attached a file for more details. Could you help me?

Thank you

sample.xlsx

[NeedForExcel]

The formula is working fine...

Apply a filter on Column A and Filter out Strandvejen 102a, the answer is 40..

Same with Sushi-Point, the answer is 6..

The Formula is working fine..

[Lan Tran]

Yes it is right

But I dont want to count the duplicate names. So all the same name should be count as 1 only, and do not count the blank.

How can I do that? The previous formula works with some of the information but not all of them

[NeedForExcel]

Hi,

You never mentioned you do not want duplicate Count..

See the attached file..

[Lan Tran]

Oh

Maybe we are misunderstood but the formulas works well. Thanks again :D

[NeedForExcel]

No Problem..

Please mark the thread as solved if you have your answer..

[NeedForExcel]

You do not need duplicates, you mentioned that in the header of the post.. I am sorry I missed it..

Cheers!