+ Reply to Thread
Results 1 to 2 of 2

How do you make a countif formula with 2 or more critera?

  1. #1
    Melissa
    Guest

    How do you make a countif formula with 2 or more critera?

    ..

  2. #2
    Paul B
    Guest

    Re: How do you make a countif formula with 2 or more critera?

    Melissa, try this, will count the number that meet test, for, and 3 in
    columns A, B, and C, 2:25

    =SUMPRODUCT((A2:A25="test")*(B2:B25="For")*(C2:C25=3))

    --
    Paul B
    Always backup your data before trying something new
    Please post any response to the newsgroups so others can benefit from it
    Feedback on answers is always appreciated!
    Using Excel 2002 & 2003

    "Melissa" <Melissa@discussions.microsoft.com> wrote in message
    news:B0DA562F-29D7-4E78-BED3-0B0B51EB0C51@microsoft.com...
    > .




+ 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