Forum Discussion
TurkiAlhamed
Oct 06, 2022Copper Contributor
Looking for formula
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...
OliverScheurich
Oct 06, 2022Gold Contributor
=COUNTIFS($D$2:$D$19,D2,$C$2:$C$19,"citizen")/COUNTIF($D$2:$D$19,D2)Maybe with COUNTIFS and COUNTIF.