My problem is I have a large excel database and need the Geomean of 365 numbers. This exceeds excels maximum number so I need to calculate using the log mean formula for geomean.

This is just a sample model of the large database

Sheet 1
A B C
1 23 45 18
2

Sheet 2
A B C
1 50 60 70
2

I use the following formula to get the Geomean using the log mean method

=EXP(AVERAGE(LN(Sheet1!A1:C1),LN(Sheet2!A1:C1)))

This gets the log mean of all numbers in Sheet1 and Sheet2.

My problem is I need to check that there are no zeros before performing the log mean. Here is a formula that checks for zeros then calculates the log mean(geomean)

=EXP(AVERAGE(IF(ISNUMBER(Sheet1!A1:C1),LN(Sheet1!A 1:C1))))

This formula is for Sheet1 only.

What I need is a formula that checks for zeros for Sheet1 and Sheet2 and then calculates the log mean (geomean) of numbers in Sheet1 and Sheet2 and places the answer on Sheet3. I can’t seem to put all of this in one formula.