Results 1 to 2 of 2

Thread: Add Overs in Cricket

  1. #1
    Junior Member
    Join Date
    Apr 2011
    Posts
    1
    Rep Power
    0

    Add Overs in Cricket

    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

  2. #2
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,123
    Rep Power
    10
    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)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •