Asking you to add a range of cells is a path to being a bit cleverer with the formula! It will make it very clear to me the order of severity and what you want to appear in all circumstances.