Countifs Help with multiple columns in one criteria

Hi, I was wondering if anyone could help me with this issue. I have a database with codes for each unit for example different age groups are coded with A so they would read as A1, A2 and so on depending on the range. Same with Nationality for B1, B2, B3. This data is huge and I am trying to count the codes received from each code column. There are 4 columns for codes which are like A1 B1 B2 C1. and my table looks the the following:
Capture.PNG

My formula to count all the A1 matched with year 2016 looks like the following: COUNTIFS(DATABASE!$R$14:$R$382,"2016",DATABASE!$N$14:$Q$382,B6)

Cell B6 corresponds to my code A2. The first range corresponds to the year on the database and the second range corresponds to the four columns that specify the code.

This formula is not working as it gives me #VALUE!

Please post a small sample file as many of us cannot view PNG images nor can we work with them.

Here it is I need to # of Gifts column to add the number of A1 on the Database. The database has about 1000 codes per yearSample Database.xlsx