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.

[TABLE="width: 642"]
<colgroup><col><col span="7"></colgroup><tbody>[TR]
[TD="align: center"]GMLOS[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]7[/TD]
[/TR]
[TR]
[TD="align: center"]?[/TD]
[TD="align: center"]150[/TD]
[TD="align: center"]510[/TD]
[TD="align: center"]306[/TD]
[TD="align: center"]183[/TD]
[TD="align: center"]37[/TD]
[TD="align: center"]25[/TD]
[TD="align: center"]22[/TD]
[/TR]
[TR]
[TD="align: center"]?[/TD]
[TD="align: center"]150[/TD]
[TD="align: center"]498[/TD]
[TD="align: center"]295[/TD]
[TD="align: center"]183[/TD]
[TD="align: center"]37[/TD]
[TD="align: center"]25[/TD]
[TD="align: center"]22[/TD]
[/TR]
[TR]
[TD="align: center"]2.4278[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]12[/TD]
[TD="align: center"]11[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[/TR]
[TR]
[TD="align: center"]?[/TD]
[TD="align: center"]303[/TD]
[TD="align: center"]304[/TD]
[TD="align: center"]160[/TD]
[TD="align: center"]100[/TD]
[TD="align: center"]78[/TD]
[TD="align: center"]15[/TD]
[TD="align: center"]0[/TD]
[/TR]
[TR]
[TD="align: center"]?[/TD]
[TD="align: center"]292[/TD]
[TD="align: center"]304[/TD]
[TD="align: center"]160[/TD]
[TD="align: center"]100[/TD]
[TD="align: center"]78[/TD]
[TD="align: center"]15[/TD]
[TD="align: center"]0[/TD]
[/TR]
[TR]
[TD="align: center"]?[/TD]
[TD="align: center"]11[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[/TR]
</tbody>[/TABLE]

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.