i want to count the number of blanks in a column, but the number of rows continually expands. how do i name a range so that it adjusts to the number of rows there currently is?
=countif(A1:A45,"") where A1:45 is the named range instead
Thanks in advance!
=countif(A1:A45,"") where A1:45 is the named range instead
Thanks in advance!