Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Aug 2004
    Posts
    361
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Countif across a number of sheets (XP)

    I have 8 tabs labeled as A-C though V-Z for alphabetical purposes. If I use =Counta('a-c:v-z'!A3:A312) I can get a count of all names in column A for the workbook. If I try =CountIF('A-C:V-Z'!C3:C312,"x") in order to count all "x" in column C I get a Value error. Is what I am attempting to do, not possible? That is, use a countif on all sheets in a workbook. Thanks.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Countif across a number of sheets (XP)

    Countif does not work on multiple sheets (the 3d formulas are not supported). Try the references in <post:=562,805>post 562,805</post:>

    Steve

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

    Re: Countif across a number of sheets (XP)

    More options in the thread starting at <post:=73,094>post 73,094</post:>.

Posting Permissions

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