Need help solving Geometric Mean (GeoMean) #NUM! error in Calc

I just embarked on a large climatology study. Besides looking at daily data, I was also doing one year running means. I converted temperatures to Kelvin, (+273.15) so I could run all three one year means. Raw data was saved in new columns with blank cells (“”) for missing data. And there is enough missing data to take into account. There can be fewer than 10 a year or more than 30. Both Average() and Harmean work fine. However I have a persistent error with Geomean where it throws a #NUM.

There is a consistent pattern that triggers this. If I run Geomean(A100,A466), I get a 1 year mean, even with missing data in the range. A100 OR A466 can be blank but both A100 and A466 will trigger a #NUM!.

Is this solvable?