Function to calculate a total on filtered table

Hi you all,

I created this function to calculate a total on a table while some filters are active:

Please Login or Register  to view this content.

How to use is:

ref expects the complete table including headers
col expects the column number to use for the sum

Have fun with this,

Hi,

Is there a reason you wouldn't just use Subtotal or Aggregate?

Hi,

No, there is no reason to use those functions. I did not these two.