Ok, I can't see how you arrive at 16 from your example though. The numbers in G6 to I13 add up to 26.
Try this one
Formula:![]()
=INT(SUM($G$6:$I$13)/6)+(MOD(SUM($G$6:$I$13),6)/10)
Ok, I can't see how you arrive at 16 from your example though. The numbers in G6 to I13 add up to 26.
Try this one
Formula:![]()
=INT(SUM($G$6:$I$13)/6)+(MOD(SUM($G$6:$I$13),6)/10)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks