There is this huge file I have and I want to count the items in column A for each location (identified by a number in the reference sheet). Why aren't my sums working (in the first two of column B) or do I have to use CountIfs? If so, how would I phrase the countif with two conditions?
Thank you for your help,
HarriBess