GEOMEAN when I already know how many I have of each

[bee_rad]

My first post here... please be gentle

So I have a very, very large data set that I have distilled down to a table of 500 lines, summarized according to some COUNTIFS statements. Now what I need is the geometric mean of the totals.

For example, in the first row I have pasted below, I know I have 150 1's, 510 2's, 306 3's, 183 4's, 37 5's, and 25 6's, and 22 7's. I only pasted the first 7 columns - on some lines there are non-zero values out to 16. The highest value that appears in this table is nearly 100,000.

GMLOS	1	2	3	4	5	6	7
?	150	510	306	183	37	25	22
?	150	498	295	183	37	25	22
2.4278	0	12	11	0	0	0	0
?	303	304	160	100	78	15	0
?	292	304	160	100	78	15	0
?	11	0	0	0	0	0	0

<colgroup><col><col span="7"></colgroup><tbody>
</tbody>

I need to know the GMLOS on each row, knowing the count of the number on each header. Is this possible in Excel? With the one line I am able to do this manually, but obviously I can't with thousands of instances.

 

[bee_rad]

Ok so silly me - I wrote "GMLOS" - this is a geometric mean.