+ Reply to Thread
Results 1 to 3 of 3

Several Countif criteria

  1. #1
    Martin
    Guest

    Several Countif criteria

    Hi there,

    I would like to do count values greater than 20 and less than 36 in Column
    C, if looking for "B" in column A and "NO" in column B. Please extract of the
    spreadsheet below.

    Column A Column B Column C
    A YES 15
    B NO 20
    B NO 35
    B YES 36
    B NO 37
    B NO 25
    B YES 30
    B NO 10
    K YES 10
    K NO 10

    I have tried with sum and sumproduct but am not able to get it right.

    Any help much appreciated.
    --
    Regards,

    Martin

  2. #2
    Ron Coderre
    Guest

    RE: Several Countif criteria

    Try this:
    Using your data in Cells A1:C10

    D1: =SUMPRODUCT((A1:A10="B")*(B1:B10="NO")*(C1:C10>20)*(C1:C10<36))

    Does that help?
    ***********
    Regards,
    Ron

    XL2002, WinXP


    "Martin" wrote:

    > Hi there,
    >
    > I would like to do count values greater than 20 and less than 36 in Column
    > C, if looking for "B" in column A and "NO" in column B. Please extract of the
    > spreadsheet below.
    >
    > Column A Column B Column C
    > A YES 15
    > B NO 20
    > B NO 35
    > B YES 36
    > B NO 37
    > B NO 25
    > B YES 30
    > B NO 10
    > K YES 10
    > K NO 10
    >
    > I have tried with sum and sumproduct but am not able to get it right.
    >
    > Any help much appreciated.
    > --
    > Regards,
    >
    > Martin


  3. #3
    Martin
    Guest

    RE: Several Countif criteria

    Many many thanks Ron,

    It works like a dream.
    --
    Regards,

    Martin


    "Ron Coderre" wrote:

    > Try this:
    > Using your data in Cells A1:C10
    >
    > D1: =SUMPRODUCT((A1:A10="B")*(B1:B10="NO")*(C1:C10>20)*(C1:C10<36))
    >
    > Does that help?
    > ***********
    > Regards,
    > Ron
    >
    > XL2002, WinXP
    >
    >
    > "Martin" wrote:
    >
    > > Hi there,
    > >
    > > I would like to do count values greater than 20 and less than 36 in Column
    > > C, if looking for "B" in column A and "NO" in column B. Please extract of the
    > > spreadsheet below.
    > >
    > > Column A Column B Column C
    > > A YES 15
    > > B NO 20
    > > B NO 35
    > > B YES 36
    > > B NO 37
    > > B NO 25
    > > B YES 30
    > > B NO 10
    > > K YES 10
    > > K NO 10
    > >
    > > I have tried with sum and sumproduct but am not able to get it right.
    > >
    > > Any help much appreciated.
    > > --
    > > Regards,
    > >
    > > Martin


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1