Tag Archives: CELL

A trick to SUM visible columns only (without VBA)

Posted on August 29, 2015 by MF

We know that SUBTOTAL allows us to perform some basics functions like SUM, COUNT, AVERAGE, etc.  that apply to visible rows only.  However, there is no similar function for visible columns only. If we need to SUM visible columns only, we will need … Continue reading →

Rate this:

Posted in Excel Tips, Formula | Tagged , , , | 15 Comments

Put a dynamic hint for showing or hiding rows or columns hidden by Data Group

Posted on August 22, 2015 by MF

This is about using SUBTOTAL and CELL function to detect whether a row and a column is hidden respectively. When rows are hidden by Data–>Group, you will see a +/- button on the leftmost of  spreadsheet to remind you that … Continue reading →

Rate this:

Posted in Excel Tips, Formula | Tagged , , | Leave a comment