Percentage calculation

Hi,

Please help with your excel expertise to achieve following in attached excel sheet (MLS_Matrix.xlsx):

Source Data:
In worksheet "Labels (Fixed Text)", in column A I have document names. For each document I have certain fixed text labels which are listed in column B. Now we are going to translate these fixed text label from English to different languages (listed in column header C, D, E, ...)


I want to do following in Tracker worksheet:

In the table Matrix against each Document Name and Language, I want to track %age of English lables translated at any given time.

Example: For document name "Advanced Shipment Notice" and language "German", if there are 33 English labels, but in German there are only 20 corresponding translated label text the in cell D4 a percentage value 60% should appear.
This matrix should get updated automatically as translations for each label text in listed languages start filling in. Empty cells in in source data should not be counted.

Thanks for you help

Best regards,
Nitin

=1-(COUNTIFS('Labels (Fixed Text)'!$A:$A,Tracker!$B4,'Labels (Fixed Text)'!D:D,"")/COUNTIF('Labels (Fixed Text)'!$A:$A,Tracker!$B4))

Originally Posted by brokenbiscuits

=1-(COUNTIFS('Labels (Fixed Text)'!$A:$A,Tracker!$B4,'Labels (Fixed Text)'!D:D,"")/COUNTIF('Labels (Fixed Text)'!$A:$A,Tracker!$B4))

I works perfectly! Many thanks for quick response.

Best regards,
Nitin