+ Reply to Thread
Results 1 to 3 of 3

Complex counting

  1. #1
    Registered User
    Join Date
    11-28-2006
    Posts
    3

    Complex counting

    I've been trying to find a way to do a specific count on a database that I manage. I'm having alot of trouble figuring this out, hope someone can help! The database I'm using consists of 100+ multi-attribute entries (one attribute per column). The count I'm wanting to do is a multi-conditional count, using two of the attributes as the criteria. If I could stop here everything would be fine; here's where my problem arises. There are approx. 850 possible matches that the count would need to figure! That might be a bit confusing so here is an explination => There are 17 different types of attribute "A" and 50 different types of attribute "B" => "A(17)" * "B(50)" = 850 possibilities. In theory, I could run all 850 possible counts for each single entry, but that would not be worth the time it would take to do so. To throw another stick in the gears, I only want the count to run if attribute "C" has a ture/false value of true. Anyone have any ideas?

  2. #2
    Valued Forum Contributor Richard Schollar's Avatar
    Join Date
    05-23-2006
    Location
    Hampshire UK
    MS-Off Ver
    Excel 2002
    Posts
    1,264
    Hi

    Have you considered using a pivot table?

  3. #3
    Registered User
    Join Date
    11-28-2006
    Posts
    3
    Excellent advice Richard! I had thought about using a PivotTable, but with my limited experience with them I had all but thrown out the idea. I went through the online tutorial, and Tada! It works exactly as I wanted it to. Thanks again!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1