How to get unique count (frequency) for a values with two criteria

[Boubiche]

Count	Repeat	Emp #	CSR	TM	Group	Presence	Schedule	Note	Year
1	Yes	3133930	Nancy	Gab	FR	Yes	Day	N/A	2016
2	No	45490	Angela	MArvin	FR	No	Day	N/A	2015
3	Yes	48550	Gregory	Craig	EN	Yes	Day	N/A	2015
4	Yes	66810	Rolance	Catherine	EN	Yes	Day	N/A	2016
5	No	68910	Marie	Pierre	FR	No	Day	N/A	2015
6	Yes	71030	Franco	Brian	EF	Yes	Day	N/A	2015

<colgroup><col width="64" span="10" style="width:48pt"> </colgroup><tbody>
</tbody>

Hi guys,

i would need some help with this one.. seems simple enough, but for the life of me, i cant get it... please help!!
i need to calculate the total unique count (frequency) of EMP (column C), who were physically present (Yes in column J) for each of the years (2015 or 2016 in column G)

2015: i need a formula

2016: i need a formula





please please please help!!

 

[Aladin Akyurek]

control+shift+enter, not just enter...

=sum(if(frequency(if($g$2:$g$6="yes",if($j$2:$j$6=2015,$c$2:$c$6)),$c$2:$c$6),1))

 

[belkacem]

hi
try this :

 

[FDibbins]

hi
try this :

Looks like you forgot to add the formula?

 

[belkacem]

=SUMPRODUCT(($B$2:$B$7="Yes")*($J$2:$J$7=2015);$C$2:$C$7)

=SUMPRODUCT(($B$2:$B$7="Yes")*($J$2:$J$7=2016);$C$2:$C$7)

 

[Boubiche]

control+shift+enter, not just enter...

=sum(if(frequency(if($g$2:$g$6="yes",if($j$2:$j$6=2015,$c$2:$c$6)),$c$2:$c$6),1))

Oh my.. thank you so much...

will this work with several hundred rows of data?? (if i change formula .. of course..)


thanks!!

 

[Aladin Akyurek]

Oh my.. thank you so much...

You are welcome.

will this work with several hundred rows of data?? (if i change formula .. of course..)

thanks!!

Yes, it would.