Hi guys,
I was wondering if you could help me. I have been able to calculate a % success rate of steps within a particular month, but haven't found a way to average the monthly success rates so far (year to date).
Issue is that the averaging needs to restart when a new year begins.
Would any of you know what formula to use for this?
Attached is a sample of what I'm trying to achieve.
Thanks for your help,
Allard
In D2
=IF(COUNTIFS($A2:$A$100,$A2,$B2:$B$100,$B2)=1,COUNTIFS($A$2:$A$100,$A2,$B$2:$B$100,$B2,$C$2:$C$100,"Pass"),"")
In E2
=IF(COUNTIFS($A2:$A$100,$A2,$B2:$B$100,$B2)=1,COUNTIFS($A$2:$A$100,$A2,$B$2:$B$100,$B2,$C$2:$C$100,"Fail"),"")
In F2
=IFERROR(D2/SUM(D2:E2),"")
In G2
=IF(ISNUMBER(F2),IF(COUNTIF($B2:$B$100,$B2)=1,AVERAGEIF($B$2:$B$100,B2,$F$2:$F$100),F2),"")
Copy down
Life's a spreadsheet, Excel!
Say thanks, Click *
Thanks Ace_XL, that works brilliantly!
Allard
Thanks Ace_XL, that works brilliantly!
Allard
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks