+ Reply to Thread
Results 1 to 2 of 2

need Conditional counting?

  1. #1
    Registered User
    Join Date
    06-12-2009
    Location
    Denver
    MS-Off Ver
    Excel 2003
    Posts
    8

    need Conditional counting?

    Hey...

    I feel stupid posting this, but here goes. I need to make a conditional function, I think, that counts an item ONLY if it meets these conditions:
    If column F2 to F120 is a "No", and column N2 to N120 is a "FALSE", then it is counted.

    F2 to F12 is full of Yes and No, and N2 to N12 is full of TRUE and FALSE, so I want to see only the ones that are BOTH No AND FALSE. The current equatrion I am using is this:

    =IF(COUNTIF('owssvr(1)'!F2:F120,"No")>0,COUNTIF('owssvr(1)'!N2:N120,"FALSE"),"")

    But, this gives me only the number of FALSEs in the N2 to N120 column, seemingly disregarding the conditionality I am trying to make. I want it to only count how many are "No" in F2 to F120 that also have a "FALSE" in N2 to N120.

    BTW, owssvr(1) is just the other tab that this is linking to, since I am keeping my equations and graphs on a separate page from my data. Anywas, any ideas?

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    re: need Conditional counting?

    Try:

    =Sumproduct(--(F2:F120="No"),--(N2:N120=FALSE))

    where FALSE is result fo Boolean formula... if not, enclose False in double quotes too.
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

+ 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