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.
=COUNTIFS($D$2:$D$19,D2,$C$2:$C$19,"citizen")/COUNTIF($D$2:$D$19,D2)Maybe with COUNTIFS and COUNTIF.
