Recent Comments
vgmendes on LinEstGap with non-linear… 
dougaj4 on LinEstGap with non-linear… vgmendes on LinEstGap with non-linear… 
Stan on ALGLIB linear and polynomial f… dougaj4 on ALGLIB linear and polynomial f… S Rijdt on ALGLIB linear and polynomial f… dougaj4 on Fast Search Reminder 
Larry on Fast Search Reminder Fast Search Reminder… on Opening and searching pdf file… dougaj4 on Opening and searching pdf file… dougaj4 on Weighted Least Squares Regress… 
GP on Weighted Least Squares Regress… 
Kamran khan on Opening and searching pdf file… dougaj4 on 3D Frame Update 
angelgalvanc on 3D Frame Update
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
