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!
Bookmarks