Great Excel shortcut

This might sound trivial, but it is such a great Excel shortcut, that I decided to mention it here explicitly.

In order to make a sum of a certain column, the function usually used is SUM().

However, if:

– you want to ensure that if you add another row into the session, the sum would automatically calculate this row…

– you want to just paste the code and the function would do the rest…

I recommend using this function:

=SUBTOTAL(9,INDIRECT(ADDRESS(1,COLUMN())&”:”&ADDRESS(ROW()-1,COLUMN())))

Very handy!