Headcount - Countif with Vlookup?

Hi Guys,

I'm quite new here and I can see that there are a lot of excel-experts around and I thought I would give it a shot.


My issue is that I have a large large headcount file where I need to count (summon) a specific "type" IF there is a value in the month of my choice.

Etc; Headcount TYPE 1, how many headcounts of TYPE 1 do I got in JAN? The value in JAN column doesnt matter, however if its blank it should not count.

I post an example and hopefully you understand what I mean.

Thank you guys

Maybe my questions is a little vague and I apologize for that. I'll try again:

You can see that I have Headcount TYPE. Below that I have type 1 to 7. For each type we have month jan to dec.

I want for example vlookup TYPE 3. By looking at the example I attached we can see that during jan, feb and march there is no data (blanks) that means also that in the row for type 3 I should not have any count for jan-march. However from apr-dec I should get an count of 1 for each month as you can see there is only one type 3 in the list with the "data". The original file I have is HUUUGE so this is just one tiny percent of what I have stored.

In the file I have today I was able to do the same thing I'm showing you guys but with a SUMIF. With the sumif I'm able to search for a criteria (type 1-7) within a range to return the sum of the criteria I have inserted. However I have not been able to do a countif with this as the sum is just a total amount but I would also like to know how many "headcounts" I got within the different types.

I tried your suggestions and it did not seem to work like I want it to look like.