Workaround for “Formula omits adjacent cells”

By | December 18, 2017

In Excel, with the following function:


I get the error:

Formula omits adjacent cells

How can I fix the formula to avoid getting the error?


The error you are getting means that there are cells near the ones in your formula that are of a similar format and Excel thinks that you might have missed them by accident. For example, if you had

1 87
2 76
3 109
4 65

then the formula


would give a similar error. So, without seeing your source data, it is difficult to answer your question. I would recommend updating the formula as it suggests and then seeing if it then includes all the cells you want. If it doesn’t, just undo and ignore the error.

Leave a Reply

Your email address will not be published. Required fields are marked *