Hi
I am trying to build a sheet in excel 2010 to list my visits to a certain brand of coffee shop including location,date, what we had and how much we spent. I have managed most of it, but the problem is with the cell counting the number of unique shops I have visited (due to multiple visits to same branch). The formula I use includes sumproduct and countif, the problem is that every time I visit, the list gets bigger. Is there something I can add to the formula to take account of the growing range? I am happy to include my spreadsheet if required if someone can explain how. If I do the problem cell is O4. Thank you in advance.