Wonderful & simple - works for all the sample situations I've tested so far.
My actual cell contents are shown below.

=IF(C59+D59+E59+F590, C59+D59&"/"&C59+D59+E59+F59," ") To suppress 0/0

Thanks Biff,


"Biff" wrote:

Hi!

=C17+D17&"/"&E17

Biff

"Steven J." wrote in message
...
I am entering sport statistics. A player may make a number of attempts
with any number of them successful (4/4, 10/12, 0/9, etc.). I have one
column that shows the percentage of successful attempts. Players want to
know the actual number of successes over attempts. I created another
column
with the formula shown below.

=IF(ISERROR((C17+D17)/SUM(C17:E17)), 0, (C17+D17)/SUM(C17:E17))

This formula adds two columns of successful attempts (perfect & good)
divided by the total of four columns (perfect, good, poor, bad). It also
suppresses the divide by zero error.

Like Horatio, I'm interested in having the actual numbers show in the
fraction without reductions (4/4 not reduced to 1/1 or 1, 10/12 not
reduced
to 5/6, etc.). There are no standard denominators, so that line of
formatting will not work for me.

Any suggestions? Please!!!

Steven J.

"Jay Somerset" wrote:

On Sat, 18 Dec 2004 07:55:25 -0600, "Horatio J. Bilge"
wrote:


"Jay Somerset" wrote in message
...
Try the format "?/?" for a 1-digit denominator ("??/??" for a
2-digit
denominator, etc.) The "# ?/?" format does the same thing, but
allows for
numbers greater than or equal to 1 (e.g. 2-1/4). That was why you
got a
"1"
earlier.


With the format "?/?" fractions still reduce automatically. For
example, 2/2
becomes 1/1, and 2/4 becomes 1/2.

Yes -- if you want to stop reduction, you have to specify the denominator
explicitly.

Thanks for the info about "# ?/?". That's handy to know.
You're welcome.

~ Horatio