Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: COUNTIFS - Is this correct?
Thanks Thanks: 0 Likes Likes: 0

  1. #11
    Board Regular
    Join Date
    Dec 2008
    Posts
    6,742
    Post Thanks / Like
    Mentioned
    8 Post(s)
    Tagged
    0 Thread(s)

    Default Re: COUNTIFS - Is this correct?

    Quote Originally Posted by monkeyharris View Post
    Hi Jason, I tried the Sumproduct this morning but it gives a 0 result. The COUNTIFS worked great.
    It works fine for me, maybe you had parenthesis in the wrong places.

    To do a greater than count with countifs you need to use ">5", not >5

  2. #12
    Board Regular
    Join Date
    Jan 2008
    Posts
    304
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: COUNTIFS - Is this correct?

    No, the results show how many orders per month have 1, 2, 3 days notice. I still need that but i also want to sum the remaining orders over 5 day.

  3. #13
    Board Regular
    Join Date
    Jan 2008
    Posts
    304
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: COUNTIFS - Is this correct?

    The ">5" worked fine.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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