Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Dec 2003
    Location
    Perth, Western Australia, Australia
    Posts
    487
    Thanks
    75
    Thanked 2 Times in 1 Post

    Countif's (2007)

    Loungers,

    I have the following formula - =COUNTIF(Sheet2!$C$4:$C$24,Sheet1!B7) which works fine for one sheet (sheet 2), however I have 7 sheets.

    Can this formula be modified to include all sheets or do they all need to be separate with a =sum() to total the value?

    Any thoughts

    Regards

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Countif's (2007)

    Excel does not support 3D references (across multiple sheets) in COUNTIF, SUMIF and SUMPRODUCT. You can find a set of custom functions that do in this newsletter - see the article by Myrna Larson and David Hager at the end.

    Usage:

    =CountIf3D("first sheet:last sheet!C4:C24",Sheet1!B7)

    Note that the reference to the 3D range is a string delimited by quotes.

  3. #3
    4 Star Lounger
    Join Date
    Dec 2003
    Location
    Perth, Western Australia, Australia
    Posts
    487
    Thanks
    75
    Thanked 2 Times in 1 Post

    Re: Countif's (2007)

    Thanks Hans - will give it a go

    Regards

Posting Permissions

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