Ratio percentage macro resulting incorrectly.

Hello all,

The macro in this sheet named Staticfmv3Ratio3 was originally written to result a percentage number based on there number of starts wins (1sts), and placings <=4.

Cols BJ:Bl is last 3 starts only.
The original macro used to pick up col AP. I have tried to change this version to pick up col K now.

Clearly I have something wrong and my adaptation is not correct and resulting wrong results in cols W and X.

I have resulted the first 7x rows in cols BN and BO to show correct results. I have nearly 600,000 rows to process. Every name is different.

Basic calculations, 100 divided by number of starts times all 1st places for col W.
Basic calculations, 100 divided by number of starts times all places less than and equal to four, for col X.

Thanks.

Administrative Note:

Is your forum profile showing the Excel PRODUCT that you need this to work for?

Members will tailor the solutions they offer to the Office PRODUCT (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your product is for Mac, please also state this.

The three most recent Excel products are Excel 2019, Excel 2021 and MS365 - if you are using MS365, please give this name along with the version number in your profile (e.g. MS365 Version 2306). This is in the About Excel section further down the Account page.

Thanks.

I have mentioned I'm using version 2016 in my posts.
MS-Off Ver
Ms Office 2016
Thanks.

Just checking, as it's an old version.

in W2

=IF(K2=0,0,ROUNDDown(COUNTIF(BJ2:BL2,1)/K2*100,1))

in X2

=IF(K2=0,0,ROUNDDown(COUNTIFS(BJ2:BL2,""<=4"")/K2*100,1)

Thanks, Eaza Goodun, that's a perfect result for me, great that I can add extra cols and widen the range in the macro. Thanks for your help, reputation coming.

John, your col W function works, but not the 2nd col X function. Not sure where I'm going wrong there.
Thanks.

Nothing wrong with Column X results

I must have a problem my end. Thanks, John, for the two functions you have provided.

Also, thanks again to Eeza Goodun for the macro.

You're welcome: glad you have it resolved.

And thanks for the rep.