Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2004
    Posts
    6

    Unanswered: countif in combination with pivot table

    Hello all,

    The inputsheet I use, has all sorts of amount, also negative amounts and small amounts. It is about 600 rows. I want a pivottable which count only the cells with an amount above 5000. In notmal formulas you have the countif option, but the pivot table only has count.
    I cannot change the input sheet, cause the input is also used by other pivottables.
    Please some advice...

    Thanx,

    Michel

  2. #2
    Join Date
    Jun 2002
    Location
    Houston, TX
    Posts
    116
    It's not necessary to post multiple times.

    texasalynn

  3. #3
    Join Date
    Mar 2004
    Posts
    6
    thank you. this comment is very helpful.

  4. #4
    Join Date
    Nov 2003
    Posts
    9

    Re: countif in combination with pivot table

    Originally posted by wielens8
    Hello all,

    The inputsheet I use, has all sorts of amount, also negative amounts and small amounts. It is about 600 rows. I want a pivottable which count only the cells with an amount above 5000. In notmal formulas you have the countif option, but the pivot table only has count.
    I cannot change the input sheet, cause the input is also used by other pivottables.
    Please some advice...

    Thanx,

    Michel
    Hullo! Build the table, with the fields where you want them. Then, after the table is built, open the Wizard, and double-click on the field you wish to limit. You can then select values to hide. That should get you close.

    HTH :-)

    P

Posting Permissions

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