Jul 01 2022 08:50 AM
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
Jul 01 2022 09:12 AM
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)