francoiscj1
New Member
- Joined
- Aug 21, 2017
- Messages
- 32
- Office Version
- 365
- Platform
- Windows
This is my original formula for completion %:
=COUNTIF($I13:$I101,"Compliant")/COUNTA($I13:$I101)
I would like to modify the formula to get completions % by month and current year. This is what I came up with:
=SUMPRODUCT((($F$13:$F$101)>=DATE(YEAR(TODAY()),1,1))*(($G$13:$G$101)>=DATE(YEAR(TODAY()),1,1))*(($H$13:$H$101)<=DATE(YEAR(TODAY()),1,31))*(($I$13:$I$101)="Compliant"))/COUNTA($I$13:$I$101)
Is my formula correct or can it be shortened?
Thanks for the help.
=COUNTIF($I13:$I101,"Compliant")/COUNTA($I13:$I101)
I would like to modify the formula to get completions % by month and current year. This is what I came up with:
=SUMPRODUCT((($F$13:$F$101)>=DATE(YEAR(TODAY()),1,1))*(($G$13:$G$101)>=DATE(YEAR(TODAY()),1,1))*(($H$13:$H$101)<=DATE(YEAR(TODAY()),1,31))*(($I$13:$I$101)="Compliant"))/COUNTA($I$13:$I$101)
Is my formula correct or can it be shortened?
Thanks for the help.