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 ...

Most function-key shortcuts also work in Google Sheets, but you may need to enable compatible spreadsheet shortcuts from the Help menu to access some familiar Excel shortcuts.