+ Reply to Thread
Results 1 to 6 of 6

COUNTTFS depending on criteria

  1. #1
    Forum Contributor
    Join Date
    11-13-2015
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    831

    COUNTTFS depending on criteria

    Herllo all,

    I need a formula please in coulmn E and F on my spreadsheet.

    I want in column E, to count from the number of times D2 Frsh Mt AV Lmb- In Mrnd appears in column A with the text = "Not in MWP" (column B), in this example, the answer is '1' so cell F2 should say 1. If the text is not equal to "Not in MWP" (i.e the text is something else) the number is 0 which should be in E2

    this needs to go on down the cells in cell E3 and F3 onwards

    please can someone help. thanks!
    Attached Files Attached Files
    Thanks,

    R.



  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    45,474

    Re: COUNTTFS depending on criteria

    Try:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Contributor
    Join Date
    11-13-2015
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    831

    Re: COUNTTFS depending on criteria

    Thank you!

  4. #4
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,224

    Re: COUNTTFS depending on criteria

    "e2"
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    "f2"
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    45,474

    Re: COUNTTFS depending on criteria

    You're welcome. Thanks for the rep.

  6. #6
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    45,474

    Re: COUNTTFS depending on criteria

    @avk: the second formula won’t work. It needs to be:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Both formulae depend on the contents of B2 which I guess could change.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] SUM values ​​depending on several criteria - text and number criteria
    By sttipa in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-27-2022, 03:53 PM
  2. Sum across a row depending on date criteria specified
    By annaisakiwi in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-21-2021, 11:58 PM
  3. Replies: 3
    Last Post: 12-05-2019, 01:20 AM
  4. [SOLVED] How to get the value from one sheet to another depending on certain criteria
    By RobfromBDA in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-26-2019, 02:47 PM
  5. Sum depending on other criteria
    By mark0123 in forum Excel General
    Replies: 1
    Last Post: 01-09-2015, 04:55 AM
  6. [SOLVED] Resuts depending on the criteria
    By managingcrap in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-15-2014, 04:25 PM
  7. Average depending on criteria
    By dan in forum Excel General
    Replies: 4
    Last Post: 07-07-2006, 03:30 PM

Tags for this Thread

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