Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    May 2002
    Posts
    410
    Thanks
    1
    Thanked 0 Times in 0 Posts

    counting greater thans

    I have a bunch of spreadsheets with the first three columns similar to the attached. The number of "AddrA's"; i.e, 1, 2, 3 etc in column A will vary as will the number of rows. The AddrA's are 1 to 56, although not all AddrA numbers will be in each spreadsheet.

    For each of the AddrA's from 1 to 56, I would like to count the number of "Res" (column C) values greater than a certain number, which in the example is 10,000.

    I think it is an array formula, but I can't figure out the logic.

    Any suggestions?

    Thanks.
    Attached Files Attached Files

  2. #2
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    How about this non-array formula and fill it down: =SUMPRODUCT((A:A=E2)*(C:C>10000))

  3. #3
    4 Star Lounger
    Join Date
    May 2002
    Posts
    410
    Thanks
    1
    Thanked 0 Times in 0 Posts
    worked.
    thanks!

Posting Permissions

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