Excel's AGGREGATE function lets you perform calculations whilst ignoring hidden rows, errors, or other functions that appear in the data. It's similar to the SUBTOTAL function but provides more ...

You’ve probably used SUM a thousand times. Everyone has. SUM is fine for school assignments and tiny tables, but in the real world, it’s a blunt instrument. If you want totals you can actually trust, ...