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

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.

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

"NickCr" wrote:

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

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

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

HTH.

"NickCr" wrote:

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