+ Reply to Thread
Results 1 to 3 of 3

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

  1. #1
    NickCr
    Guest

    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.

  2. #2
    DaveO
    Guest

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

    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.


  3. #3
    bpeltzer
    Guest

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

    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.


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1