A possible alternative approach in Excel 2010 or later versions: AGGREGATE(6,6,A1,B1) In AGGREGATE function the first 6 indicates PRODUCT operation and the second 6 denotes "ignore errors" More @Wikipedia
Hover over any link to get a description of the article. Please note that search keywords are sometimes hidden within the full article and don't appear in the description or title.