Recent Comments
mindOnion on Drawing a Buckyball in Ex… 
dougaj4 on Drawing a Buckyball in Ex… mindOnion on Drawing a Buckyball in Ex… mindOnion on Drawing in Excel 7 – Cre… 
Veronica Davenport on Asymmetric Catenary Function py_UMom spreadsheet… on More on combined shear and ben… 
Skip on xlwings – dataframes and… dougaj4 on xlwings – dataframes and… More on combined she… on RC Design Functions 9.03; comp… skip on xlwings – dataframes and… skip on mpmath for Excel dougaj4 on mpmath for Excel skip on mpmath for Excel dougaj4 on Composite Beam Spreadsheet Upd… 
metroxx on Composite Beam Spreadsheet Upd…
Tag Archives: CHAR(173)
The Countif bug (and how to avoid it)
The Countif function counts the number of cells in a range that match some criterion. If we enter 1,2,3 in cells A1:A3 and enter =COUNTIF($A$1:$A$3,A1) somewhere else, it will return 1: But if we enter three text strings with 16 … Continue reading
Posted in Computing - general, Excel
Tagged bug, CHAR(173), COUNTIF, Excel, Sum, Sumproduct
1 Comment
Newton Excel Bach, not (just) an Excel Blog 