A formula that contains a reference to most but not all of a region of data is flagged as a formula omitting cells in a region. ...

A formula that contains a reference to most but not all of a region of data is flagged as a formula omitting cells in a region. (For example, this occurs if there is data in cells A1:A100 and a formula contains the reference "=SUM(A1:A98)".)