Hello All:

I am finishing up calculations on my masters thesis. I have about 2000
observations for about 150 bid-ask spreads for REITs (Real Estate Investment
Trusts) (way too much data for manual input). There are random empty cells
throughtout. I am trying to take a GEOMEAN for all 150 column variables. It
automatically ignores the empties when using average, but not in GEOMEAN.
What kind of formula can I use that will recognize the empty cells and ignore
them (not turn them into zeros) without registering as an error?

Thanks in advance.

(for Excel 2003)