Need Help

[satriasurya]

Please if any1 can help, i have 2 file, Group (left) and Individual (Right).
And i need to show total gender for each group in Group (left) file based on data from Individual (right).

Thanks

[#2]

Hi @satriasurya ,

you can use the countifs() function.

=COUNTIFS(Dataaerea!$B$2:$B$14,$A2,Dataaerea!$C$2:$C$14,1=for male 2=for female)