The basic formula, as you have it, is correct for Calc, however, Excel will recognize numbers entered as text, and work with them correctly in formulas Calc will not Thus, I'm going to suggest that you verify the data being fed to these formulas are numeric Excel Errors The Ultimate Guide Excel formula errors are inevitable and the more formulas you write, the more errors you'll get Understanding how to troubleshoot and fix #NULL!, #REF!, #DIV/0!, #NAME?, #N/A, #NUM!, #VALUE!, and ##### errors in Excel is something you shouldn't postponeHow to fix #NAME error in Excel?
Count Names In Excel How To Count Names In Excel With Examples
Name excel cells