View Single Post
 
Old 10-07-2015, 08:10 AM
shg shg is offline Windows 7 64bit Office 2010 32bit
Advanced Beginner
 
Join Date: Oct 2015
Posts: 55
shg is on a distinguished road
Default

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.
Reply With Quote