Right.
COUNTIF(S) and SUMIF(S) functions, unlike most others, don't allow arrays as arguments; they require ranges. So it's easy for them to intersect the ranges passed against the used range of the worksheet. So you can pass full-column references without worrying about the consequences.
|