This: "formula omits adjacent cells" is just a warning to advise you that your formula may be missing a column/row of info.. you can just ignore if you know you have covered the ranges you want.