Write a count like 15 out of 20

Turn a count of 15 and a total of 20 into 15 out of 20, keeping the real numbers.

What you'll make

In Excel: 15 and 20 becomes 15 out of 20.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1A8The count, as typed."15"
2&" out of "&Adds the words "out of" between the numbers."15 out of "
3B8The total, as typed."15 out of 20"

The numbers are kept as they are, so 6 out of 8 never becomes 3 out of 4.

=A8&" out of "&B8

How to use it

Yellow bar at the top? Click Enable Editing.

  1. See it work. The Example tab shows 20 made-up examples with the formula already in.
  2. Use your own numbers. Paste counts into column A and totals into column B of the Template tab. The statements fill in by themselves.
  3. Move them into your letter. Copy the results. Then use Paste Special and choose Values.

Before you send

Check that each count and its total cover the same group and the same time.