Build flexible Excel functions that automatically handle blanks, defaults, and overrides without messy nested IFs.
AGGREGATE was built to handle messy data from the start.