Is it normal to count empty rows when selecting the entire column?

khankoff

I have a formula that looks like this:

=SUMIF([Request Status]:[Request Status], "5-Complete", [Est Days to Scan]:[Est Days to Scan])

I've noticed that in each of the two columns referenced in my formula, the selection includes 10 rows of blank cells below the last populated cell.  Is this normal?  

Andrée Starå

Hi Ken,

Yes, it's normal. There are always ten more rows added and ready for new information.

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

khankoff

Thanks, Andree.  You're a rock star (as usual).

Stay tuned - I'm about to post another question.

Andrée Starå

Happy to help! Bring it on!