=SUMPRODUCT glitching with cricket stats
Hello all!
I have a small issue with my excel sheet when it comes to counting overs. So in cricket an over is 6 balls, so for example if I bowled 17 balls it would read 3.5overs done. So for my spreadsheet I wrote a code that would allow me to imput the number of overs bowled and it'd automatically show me how many balls were bowled in the next coloumn.
Now my issue arrises when after a few years of playing I've bowled 913 overs but the spreadsheet is glitching out and showing 912.6 which is incorrect in cricket. (Below is the overs in year order to help visualise what I mean)
2020: 61.5 2021: 143.4 2022: 152 2023: 164.1 2024: 147.1 2025: 191.1 2026: 53
total: 912.6 but the .6 should roll over to 913. It's causing me a tiny bit of a headache but if anyone has a fix that would greatly be appricated.
Code used; =SUMPRODUCT(INT(B2:B8))+INT(SUMPRODUCT(MOD(B2:B8,1))/0.6)+MOD(SUMPRODUCT(MOD(B2:B8,1)),0.6)
Any help would be welcomed
[link] [comments]
Read on the original site
Open the publisher's page for the full experience