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