Tag Archives: bug

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 , , , , , | 1 Comment

A very un-useful “feature”

A recent post in the Engineering Spreadsheets forum at Eng-Tips draws attention to a potentially dangerous Excel “feature”. The feature is called “Extend data range formats and formulas” and can be found under Options-Advanced (click on the multi-coloured button in the … Continue reading

Posted in Excel | Tagged , | 1 Comment