I need help with a formula for cricket stats!
 

What you could do is us the little know fraction format for cells.

Enter the following in some cells
1 1/6 ie 1 space 1/6
1 3/6 etc

When you add these up, they will sum correctly.

Matt


--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514
View this thread: http://www.excelforum.com/showthread...hreadid=554773