Very handy 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!


Warning: Use of undefined constant rand - assumed 'rand' (this will throw an Error in a future version of PHP) in /home/ay015300/_sub_boros/martin/wp-content/themes/greenchilli/single.php on line 47

Leave a Reply

Your email address will not be published. Required fields are marked *