|
|
#5
10-07-2015, 08:10 AM
|
|||
|
|||
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. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 CountA function to Count Blanks
|
Alaska1 | Excel | 10 | 02-11-2015 04:20 PM |
|
Is it possibly to lock a table ?
|
spookiepower | Word | 2 | 09-07-2013 08:55 AM |
| COUNTA function returns incorrect value | joeller | Excel | 2 | 10-16-2012 05:37 AM |
| Advanced ToC problem (possibly) | norby | Word | 4 | 05-08-2012 12:02 AM |
| Possibly a VLookup | mrswarrick | Excel | 3 | 01-13-2012 11:12 AM |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode