COUNTA only counts null values if the nulls are results of formula, e.g. =IF(A1=1,1,""). If you don't include the -1 then a the range includes one blank cell at the bottom, since you started at row 2 and added the COUNTA() result.
COUNTA only counts null values if the nulls are results of formula, e.g. =IF(A1=1,1,""). If you don't include the -1 then a the range includes one blank cell at the bottom, since you started at row 2 and added the COUNTA() result.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks