Recent Comments
Numerical Integratio… on Numerical integration with on-… 
josh on Import Data from a Picture to… Melanie Safka + Mile… on Melanie Safka 
Mohd Yousef on Biaxial bending update 
DonB on Biaxial bending update Mohd Yousef on Biaxial bending update 
dougaj4 on Biaxial bending update DonB on Biaxial bending update dougaj4 on Biaxial bending update DonB on Biaxial bending update 
Mohd Yousef on Biaxial bending update dougaj4 on Beam Fixed End Actions by Maca… 
Peka Odendaal (@PKOd… on Beam Fixed End Actions by Maca… 
Gerardo Freyre on The history of the theory of b… dougaj4 on Time in hours and minutes betw…
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
