Godders199
Active Member
- Joined
- Mar 2, 2017
- Messages
- 313
- Office Version
- 2013
Hello, I am trying to work out the formula which counts if criteria is met, and then calculates the % of the total in the same cell, for example
cell C6 is the total , currently 15
Cell d6 displays total matching criteria in first part of formula 3
so in cell d6 i want to display 3 (20%)
I have tried various formulas i have found on the internet, for the % but can get none to work, SO the countifs bit is fine, its just after the & i cannot work out.
=COUNTIFS('QA Checks'!$C:$C,"QA Check",'QA Checks'!$D:$D,"mpm-fc",'QA Checks'!$E:$E,">="&'Monthly MI'!$A1,'QA Checks'!$E:$E,"<="&'Monthly MI'!$A2,'QA Checks'!F:F,"suitable")&" sum(D6/C6)*100&"%)"
Any help would be appreciated.
cell C6 is the total , currently 15
Cell d6 displays total matching criteria in first part of formula 3
so in cell d6 i want to display 3 (20%)
I have tried various formulas i have found on the internet, for the % but can get none to work, SO the countifs bit is fine, its just after the & i cannot work out.
=COUNTIFS('QA Checks'!$C:$C,"QA Check",'QA Checks'!$D:$D,"mpm-fc",'QA Checks'!$E:$E,">="&'Monthly MI'!$A1,'QA Checks'!$E:$E,"<="&'Monthly MI'!$A2,'QA Checks'!F:F,"suitable")&" sum(D6/C6)*100&"%)"
Any help would be appreciated.