SUM only the visible cells and cells with no errors in Excel

Описание: How to get a total using only the visible cells in Excel.

The function allows you to perform any one of these functions: count, counta, max, min, product, stdev.s, stdev.p, sum, var.s, var.p, median, mode.sngl, large, small, percentile.inc, quartile.inc, percentile.exc, quartile.exc

using any one of these combinations:
Ignore hidden rows, nested SUBTOTAL and AGGREGATE functions,
Ignore error values, nested SUBTOTAL and AGGREGATE functions,
Ignore hidden rows, error values, nested SUBTOTAL and AGGREGATE functions,
Ignore nothing,
Ignore hidden rows,
Ignore error values,
Ignore hidden rows and error values