Excel's Data > Filterfeature provides a simple way to quickly hide rows from a table or … See more

The SUBTOTAL function can be used to sum and count values, ignoring hidden cells, so we can use SUBTOTAL to detect if a row is hidden. The Filter column in our Contact Lis… See more

For this technique, you can use an INDEX-MATCH lookup formulainstead of the OFFSET function. That is why the Data worksheet has a Row column. First, in the Data works… See more