Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Nov 2002
    Location
    London, Gtr London, England
    Posts
    496
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Count based on two conditions

    Dear loungers

    Some time ago "Retired"Geek gave me this solution to wanting to create summary figures based of two conditions.

    I have used this principle a lot and it works well. however, if you have a large number of categories to summarise - i have a matrix of 25 categories by 6 status values it is a little unwieldy -if only in the setting up, and pray that some bright spark doesn't suggest another status value. So I am wondering if there is another way to do this?

    Thank you...................... liz
    Attached Files Attached Files

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,435
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Liz,

    How about a simple pivot table?


    P.S. Your sample data had "raised" and "raised " which caused two columns to appear when I first tried it. You have to be careful with leading and trailing spaces. It would be a good idea to use data validation to prevent this.
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by RetiredGeek; 2012-11-05 at 12:06.
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

Posting Permissions

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