Help with displaying Sum/Count expressed as a fraction

[landmark33]

	A	B
1	0	0/1
2	1	1/2
3	1	2/3
4	0	2/4
5	1	3/5
6	0	3/6

<tbody>
</tbody>

See above chart. In column A, I will have either 0 or 1 entered manually. For column B, I want to create a formula that is basically SUM/COUNT.

So for example cell B6 is something like =[sum(a1:a6)]/[count(a1:a6)]

I'm not sure if I have that exactly right, so please help me create this formula accurately. But the really tricky part here is I want column B to be expressed as a fraction as shown above.

Thanks!

 

[pgc01]

Hi

Try:

=sum(a1:a6)&"/"&count(a1:a6)

I'm assuming you don't want the fraction simplified

 

[Noodleski]

Aren't fractions offered standard in the cell properties? Right between percentage and scientific.

 

[pgc01]

Aren't fractions offered standard in the cell properties? Right between percentage and scientific.

Hi

Yes, but as number values, meaning it will simplify like you do in Math.

For ex., format a cell as fraction and enter the formula

=5/10

you'll see in the cell

1/2

For some cases it's what you want, in other cases it may not be.

In the case of the OP, 5/10 means there were 10 occurences and 5 of them were 1, it gives you more information that 1/2 which simply tells you that half of the occurences had a 1 but not how many occurences there were.

That's why I asked if the fraction could be simplified.

 

[landmark33]

Correct. I do not want the fractions simplified. That's why in my example chart I had in B6 as "3/6" and not "1/2".

I'll try the formula out later and report back. Thanks!

 

[landmark33]

Yep. That does it. Thanks pgc01!

 

[pgc01]

You're welcome. Thanks for the feedback.