Results 1 to 6 of 6

Nested COUNTIF

Threaded View

  1. #1
    Registered User
    Join Date
    11-19-2007
    Posts
    3

    Nested COUNTIF

    I am trying to use a countif with other qualifying variables frm other columns in the same row.

    I want to get a count of non numberical data in 2 colums if both conditions are met.

    I would like to make this happen:
    =countif (c1:c100,"YES") if (A1:a100)="X"
    Do not count if the data in A is not an X. X is the actual data, not a placeholder.

    I tried SumProduct and SumIf, and Count(If...) but I am missing something someplace.

    Anyhelp is appreciated.
    Last edited by Leith Ross; 11-19-2007 at 02:22 AM.

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