1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

=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

submitted by /u/GiordySays
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#no-code spreadsheet solutions
#natural language processing for spreadsheets
#modern spreadsheet innovations
#machine learning in spreadsheet applications
#generative AI for data analysis
#enterprise-level spreadsheet solutions
#digital transformation in spreadsheet software
#Excel compatibility
#collaborative spreadsheet tools
#AI-driven spreadsheet solutions
#cloud-based spreadsheet applications
#automation in spreadsheet workflows
#AI-powered spreadsheet
#Excel alternatives
#spreadsheet API integration
#rows.com
#financial modeling with spreadsheets
#SUMPRODUCT
#cricket