+ Post New Thread
Results 1 to 4 of 4
Office Software Thread, Countif multiple criteria in Technical; Hello, I think I read once that you can define a name for an array of terms and then call ...
  1. #1

    Join Date
    Nov 2006
    Location
    Lancashire
    Posts
    95
    Thank Post
    34
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Countif multiple criteria

    Hello,

    I think I read once that you can define a name for an array of terms and then call that list as criteria in a CountIf or SumIf formula but now I can't find any material on it.

    So for example your list called 'colours' might be {"green", "yellow", "blue", "brown"}

    and you could do something like: =countif(range, {colours})

    Does anyone know if this is possible or was it a beautiful dream?

    Thanks,

    Ben

  2. #2
    apeo's Avatar
    Join Date
    Sep 2005
    Location
    Lost
    Posts
    1,612
    Thank Post
    95
    Thanked 115 Times in 111 Posts
    Rep Power
    42
    Think you need dcounta.

    Code:
    =dcounta(database,field,criteria)

  3. #3
    apeo's Avatar
    Join Date
    Sep 2005
    Location
    Lost
    Posts
    1,612
    Thank Post
    95
    Thanked 115 Times in 111 Posts
    Rep Power
    42
    Heres an Example:

    Say your table is =

    Colours
    Brown
    Green
    Brown
    Yellow
    Yellow
    Green
    Blue

    If you want to count how many Brown and Green then you need to create a criteria table =
    Colours
    Brown
    Green

    Your formula will look like this =
    Code:
    =dcounta(A1:A8,"Colours",A10:A12)
    Your database table is in the range A1:A8 and your criteria table is in the range A10:A12

  4. Thanks to apeo from:

    park_bench (15th June 2009)

  5. #4

    Join Date
    Nov 2006
    Location
    Lancashire
    Posts
    95
    Thank Post
    34
    Thanked 1 Time in 1 Post
    Rep Power
    0
    Great thanks! I'll have a play with that.

    Ben



SHARE:
+ Post New Thread

Similar Threads

  1. [MS Office - 2003] Excel - Countif ("A*") problem
    By park_bench in forum Office Software
    Replies: 5
    Last Post: 6th May 2009, 10:59 PM
  2. [MS Office - 2003] COUNTIF Fuction
    By vunsev in forum Office Software
    Replies: 8
    Last Post: 9th March 2009, 07:01 PM
  3. Powerpoint Multiple
    By ICT_GUY in forum Wireless Networks
    Replies: 4
    Last Post: 1st May 2008, 12:42 PM
  4. Support criteria
    By Ryan in forum General Chat
    Replies: 5
    Last Post: 15th February 2008, 10:56 PM
  5. Multiple monitors
    By netadmin in forum Windows
    Replies: 9
    Last Post: 25th January 2007, 01:41 AM

Thread Information

Users Browsing this Thread

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

Posting Permissions

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