Google Sheets
How to Combine Percentages From Groups of Different Sizes
Published by OneCell
To find the overall finished share across groups, add the finished counts and divide by the combined total. Keep the counts behind each percentage so a small group and a large group contribute their actual numbers of items.
Start with the counts in each batch
Imagine a community archive labeling two batches of identical catalogue cards. Each card belongs to one batch. In both batches, finished means the label is attached and checked. All counts describe the same reporting snapshot.
The small batch has 2 of 2 cards finished, or 100%.
The large batch has 1 of 8 cards finished, or 12.5%.
Across the two batches, 3 cards are finished out of 10. The overall share is 30%, calculated as (2 + 1) ÷ (2 + 8).
The arithmetic mean of the two batch percentages is 56.25%, calculated as (100% + 12.5%) ÷ 2. That gives each batch equal influence. For the share of all cards finished, each card contributes equally, so the larger batch carries more weight. Google’s weighted-average documentation describes applying a corresponding weight to each value. Google’s weighted-average reference
Put the counts in Google Sheets
On a tab called Batches, enter Batch in A1, Finished in B1 and Total in C1. Put Small, 2 and 2 across row 2. Put Large, 1 and 8 across row 3.
Check that all counts are known, numeric and nonnegative, with each finished count no greater than its total. Put this formula in F1.
=IF(SUM(C2:C3)=0, "No items", SUM(B2:B3)/SUM(C2:C3))
SUM adds the counts, and IF displays No items when the combined total is zero. Format F1 as a percentage to display 30%. Google’s SUM reference and IF reference
Check a change and the boundaries
Change B3 from 1 to 4. There are now 6 finished cards out of 10, so F1 should display 60%. The equal-batch mean would be 75%, from 100% and 50%.
If both batches explicitly have zero cards and zero finished, set B2:C3 to zero. Expect No items. With a total of zero, the percentage is undefined. Google’s division reference
If any count is unknown, establish it before reporting the overall share. A blank input needs attention even if the formula produces a result. Restore the original counts to repeat the example.
When combining your own groups, check that they count the same unit, use the same finished definition and cover the same period. Resolve any overlapping membership before adding totals. If you add rows, extend both formula ranges together.