News
Excel COUNTIF Function " Count Cells That Meet One Condition (and the Criteria Traps)
7+ hour, 23+ min ago (554+ words) TL; DR " COUNTIF(range, criteria) counts how many cells in range meet one condition. The whole function turns on one fact most people miss: the criteria is a piece of text " a little test written as a string. Get that,…...
Excel AND & OR Functions " Combine Conditions Right (and Why Excel Never Short-Circuits)
3+ day, 7+ hour ago (688+ words) AND and OR look like the most basic functions in Excel, and in isolation they are. But almost every real bug with them comes from a single misunderstanding: people treat them as if they make a decision, when all they…...
VBA By Ref vs By Val in Excel " Why Your Variable Changed After a Call
1+ mon, 19+ hour ago (729+ words) Tested on: Excel 365 v2509 " Excel 2021 " Excel 2019 " last verified 2026-06-07 TL; DR " By Ref passes the original variable, so a procedure can change it. By Val passes a copy, so the original is safe. VBA defaults to By Ref " which is why a…...