Recent Comments
Brad Clarke on Section properties for groups… 
dougaj4 on Section properties for groups… Brad Clarke on Section properties for groups… Brad Clarke on Section properties for groups… dougaj4 on Dots and Crosses 
Stephen Cooke on Dots and Crosses dougaj4 on Two songs = 2/3 Wikipedia 
Tom Barsh on Two songs = 2/3 Wikipedia 
Jon Peltier on Two songs = 2/3 Wikipedia Returning Arrays Fro… on More Numpy with Excel and… More Numpy with Exce… on Using Array Functions and… More Numpy with Exce… on Sorting with Python and N… Office Insiders and… on JavaScript UDFs in Excel Sorting with Python… on Sorting with VBA and Pyth… Sorting with VBA and… on Dynamic sorting with Excel, VB…
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
Leave a comment
