Problem: What if you don't delete the past employees, but you hide the rows? The newer AGGREGATE function can ignore hidden rows.
In the figure below, the first argument of 3 tells Excel to use the COUNTA function. The second argument of 5 tells Excel to ignore hidden rows.
- AGGREGATE can ignore errors, other subtotals, or hidden rows.