I have a spreadsheet with two named ranges: Dates and City
I'd like to find in G3
all orders placed in the year 2012 in, for example, New York
I tried formulae with Countif but it didn't work. Any suggestions? I shouldn't use PT.