I think I need basic help with a formula

I am trying to setup a spread, sheet to count how many different branches of a certain coffee shop I visit. I enter where, when I go. How much I spend etc, but the problem is getting the sheet to count how many unique shops I visit from many re visits. I have tried to enter a range of where the info will eventually go. But it doesnt like dealing with blank cells. The formula (=SUMPRODUCT(1/COUNTIF(B5:B22,B5:B22)) I am using came from a help film on you tube but I have to keep changing the range after every visit. Is it possible to automate this? 

I am using laptop, windows 10, excel 2010