Archive for 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 visible data in a table and return multiple values
This post describes how to search visible values and return multiple values from a table. Some rows are hidden because […]
The SUBTOTAL function lets you sum values in a cell range that have some rows hidden or filtered, the picture […]