Excel's AGGREGATE function lets you perform calculations whilst ignoring hidden rows ... input. You can see both syntaxes in use when I show you some examples soon. The syntax for the reference ...