Looking for formula

Copper 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.



1 Reply



Maybe with COUNTIFS and COUNTIF.