Help with displaying Sum/Count expressed as a fraction

[landmark33]

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]0
[/TD]
[TD]0/1
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]1
[/TD]
[TD]1/2
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]1
[/TD]
[TD]2/3
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]0
[/TD]
[TD]2/4
[/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]1
[/TD]
[TD]3/5
[/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD]0
[/TD]
[TD]3/6
[/TD]
[/TR]
</tbody>[/TABLE]


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.