Results 1 to 3 of 3

Nested COUNTIF and IF Formula

Threaded View

  1. #1
    Registered User
    Join Date
    04-24-2015
    Location
    Manchester, England
    MS-Off Ver
    Office 365 2013
    Posts
    7

    Nested COUNTIF and IF Formula

    Hi All,

    I am trying to create a formula that will do the following:

    Count if H:H >= H21.

    AND in the corresponding row

    F:F="Answered"

    I don't know if I have explained myself correctly there... let me know if you need any more information.

    Thanks,

    James
    Last edited by neurion; 12-04-2015 at 05:34 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Dynamically Update CountIf Formula Based On Nested List
    By SamuraiSam83 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-13-2015, 09:09 PM
  2. Replies: 8
    Last Post: 12-31-2014, 11:48 AM
  3. [SOLVED] Need Help with nested COUNTIF formula
    By Mark_12345 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-10-2014, 01:31 PM
  4. [SOLVED] Nested?, Countif function or sumproduct formula, please need a tip
    By david gonzalez in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 05-23-2014, 11:44 PM
  5. [SOLVED] Trouble with nested IF-COUNTIF Formula
    By Ford Sakata in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-10-2013, 01:45 PM
  6. COUNTIF & IF mixed/nested formula help
    By Nick.C in forum Excel General
    Replies: 15
    Last Post: 01-31-2012, 08:13 PM
  7. help on a nested countif/nested if formula
    By vickiemc in forum Excel General
    Replies: 2
    Last Post: 08-13-2008, 08:29 AM

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