Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    May 2007
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Count with multiple criteria (2002)

    Edited by HansV to provide more descriptive subject

    Hi everyone
    I'm trying to count the occurences of two different things in two columns =COUNT(IF((C3:C120=G2),(E3:E120=G8))) I've set this as an array but no joy. gives me a 0 or some strange result.
    I've also tried this but nada =COUNT(IF((C1:C120=G2),AND(E1:E499=G8)))
    I kinda understand that countif wont do mutiples and someone suggested dcount but I'm getting lost.
    I hope this makes sense?
    thanks so much
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Count with multiple criteria (2002)

    Welcome to Woody's Lounge!

    The formula would be

    =SUMPRODUCT((C3:C120=G2)*(E3:E120=G8))

    or as an array formula (confirm with Ctrl+Shift+Enter)

    =SUM((C3:C120=G2)*(E3:E120=G8))

    but it doesn't make much sense since G8 is empty in all worksheets.

  3. #3
    New Lounger
    Join Date
    May 2007
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Count with multiple criteria (2002)

    Thanks a lot Han's.
    I tried it and it works
    Dont know why G8 was empty in what I sent you(it was the 4th worksheet in).
    I always think of Sum to be add up aritmetically not count occurences of.
    And * (multiplied) by also threw me but I'm wiser now.
    thanks for making my 5 hours on a Friday night a wise investment![img]/forums/images/smilies/smile.gif[/img]

Posting Permissions

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