Results 1 to 3 of 3
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Counting Cells (Office 97)

    Can anyone tell me how to count just the subtotal cells. I use counta all the time in a normal spreadsheet but I dont think it works in this case.

    Also is possible to color the tabs in worksheet
    Thanks in advance
    If you are a fool at forty, you will always be a fool

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Counting Cells (Office 97)

    As far as I know nobody has found a way to color the tabs in a workbook for versions of Excel prior to 2002. XL 2002 does support different colors for each tab.

    For sub totals use the SUBTOTAL function with th efollowing syntax :

    =SUBTOTAL(Function, Range)

    where Function is one of the following values :

    1 AVERAGE
    2 COUNT
    3 COUNTA
    4 MAX
    5 MIN
    6 PRODUCT
    7 STDEV
    8 STDEVP
    9 SUM
    10 VAR
    11 VARP

    e.g. to count the items in a range use =SUBTOTAL(3,Range)

    Andrew C

  3. #3
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Counting Cells (Office 97)

    Thanks very much Andrew
    This is a big help.
    If you are a fool at forty, you will always be a fool

Posting Permissions

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