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

khankoff ✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

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?  



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!