Looking for formula

New Contributor

Hi Everyone 

 

I am working on a big data file to do some statiscts report, one of the caritera is to show the nationalism rate in each department and position, for example is we have 4 citizen and 7 expats in finance, the nationalism rate for finance would be (4(number of citizens)/11(total number of staff)=36%

on a larger scale i want to build a formula that can calculate, the percentage of citizens in each department.

TurkiAlhamed_0-1665046933482.png

 

1 Reply

@TurkiAlhamed 

=COUNTIFS($D$2:$D$19,D2,$C$2:$C$19,"citizen")/COUNTIF($D$2:$D$19,D2)

Maybe with COUNTIFS and COUNTIF.

departments.JPG