How do I create autosum formula to show totals for visible data on

[NickCr]

I am trying to create an autosum to display totals for a particular column at
the bottom of the colum, however I only want it to show the totals for the
data visible at that time. E.g ig I have selected certain variables from the
drop down columns at the top (uk/ireland figures for example) I want it to
update the autosum total to just show the total for these variables (e.g.
Sales figure UK/Ireland and not other countries that are hidden) rather than
still showing the total for the whole column.

 

[bpeltzer]

If your means of hiding is a filter, then the subtotal function (as opposed
to sum) will do the job. Change =sum(range) to =subtotal(9,range). Or, if
you turn on the filter first and set one or more filter criteria, then the
autosum button will create the subtotal function for you.
HTH. --Bruce

 

[DaveO]

Try using the =SUBTOTAL(109, {DATA}).

Have a look in the HelpFile for this and it should help!

HTH.