Prevent broken formulas using tables, validation rules, separate worksheets, named variables, and the power of LAMBDA.
AGGREGATE was built to handle messy data from the start.