Add Overs in Cricket

[MrDelhi]

Hi All,

I would like add the overs (An over consists 6 balls. 1.2 + 1.4 =3) bowled by the bowlers. For e.g.,

Bowler Overs
Bowler 1 10
Bowler 2 10
Bowler 3 8.2
Bowler 4 1.4
Bowler 5 10


the total will be 40.

Any help would be appreicated.

Thanks

[Admin]

Hi,

One option would be

=SUMPRODUCT(INT(A2:A6))+INT(SUMPRODUCT(MOD(A2:A6,1 ))/0.6)+MOD(SUMPRODUCT(MOD(A2:A6,1)),0.6)