Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2006
    Posts
    162

    Unanswered: Multipel Countif

    lets say i have two rows of data like so

    AM,Yes
    PM, No
    AM, Yes
    AM, No

    So the time frame is in one column and the yes/no is in the next.

    I want to count how many time a certain combo happens according to row.

    Like AM and Yes occur 2 times
    PM and No occur 1 time
    AM and No occur 1 time

    How would i do this?

  2. #2
    Join Date
    Sep 2006
    Posts
    162
    Sorry just figured it out using the sumproduct

Posting Permissions

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