As a result of using a named range rather than direct cell references, I can guarantee that I've not accidentally selected the wrong cells. What's more, because the referenced ran ...

Excel's AGGREGATE function lets you perform calculations whilst ignoring hidden rows, errors, or other functions that appear ...