SUBTOTAL function
Excel » Functions » Math and trigonometry » SUBTOTAL function »
Learn how to use the SUBTOTAL function
The picture above shows row 4 and row 8 hidden, the SUM argument 9 sums all values in C3:C11 whereas […]
VLOOKUP in a filtered Excel Table and return multiple values
This post describes how to search filtered values in an Excel defined Table using a condition given in cell 12 and return […]
The SUBTOTAL function lets you sum values in a cell range that have some rows hidden or filtered, the picture […]