Hello,

Currently I need

=COUNTIFS(B:B, "WA",D:D, "2006",A:A, "Bellingham")+COUNTIFS(B:B, "WA",D:D, "2006",A:A, "Anacortes ")

to work. Basically It needs to recognize if it's from 2006 and this state and if it's either one of these two cities.

I'm stuck and thought the above function would work, but it doesn't.

Help would be be very much appreciated.