Help with functions and percentages

[stu40622]

I have amounts in G2 through G11 and H2 through H11. Here's what i
looks like:

G2 941173
G3 1108571
G4 1890223
G5 2363163
G6 6930592
G7 8368082
G8 9476946
G9 9813421
G10 11050700
G11 11198647

H2 692611
H3 771615
H4 1456956
H5 1879724
H6 7740927
H7 8958217
H8 10205869
H9 10501366
H10 11744353
H11 11804834

In rows 14 and 15, I have to use formulas in column H to find th
percentage of the total numbers in G and H, formatted with two decima
places. The answers are 48.68 for G and 51.32 for H, but I don't kno
what formula I use to get those answers. Any help would be greatl
appreciated

 

[JE McGimpsey]

One way:

H14: =SUM(G2:G11)/SUM($G$2:$H$11)
H15: =SUM(H2:H11)/SUM($G$2:$H$11)

Format both as percentage with two decimal places.

Note that I get 49.99% and 51.01%, not your values. If G2:H11 are
calculated, then rounding errors could be the difference.