Find number of active employees with specific skill

[pan31geo]

Hello,

I have a database that I need to find out per year how many employees are active with a specific skill. To help you out the format is
Column A start date within the business (2012-2017 with full date ddd/mmm/yyy)
Column B end date within the business (2012 -207 with full date ddd/mmm/yyy)
Column C skill ( for the example let's say it is red,blue,yellow)

I need to find how many are active on each year (even if I have months recorded in the database I only need the year) with each skill.

I was thinking sumifs but seems to be wrong unless I format it in the wrong way.

Any help would be greatly appreciated as it is quite an urgent need.

 

[Aladin Akyurek]

Something like:

=SUMPRODUCT(--(YEAR($A$2:$A$10)>=2012),--(YEAR($B$2:$B$10)>=2012),--($C$2:$C$10="red"))

which does a count for red in 2012.

Also:

=COUNTIFS(A:A,">="&DATE(2012,1,1),B:B,">="&DATE(2012,1,1),C:C,"red")