+ Reply to Thread
Results 1 to 4 of 4

Adding a COUNTIF function to an existing IF AND COUNTIF Formula...

  1. #1
    Forum Contributor
    Join Date
    02-09-2016
    Location
    West Midlands
    MS-Off Ver
    2016
    Posts
    224

    Adding a COUNTIF function to an existing IF AND COUNTIF Formula...

    Hi,

    Thanks for all those who have been kind enough to help me, i've really learned a lot since starting to use Excel and VBA. This Forum and its contributors have been the best help i have found, so thank you!


    In a previous post i required a COUNTIF function and i was shown how to which lead to the following code;

    Please Login or Register  to view this content.

    This works perfectly....


    Since going through some of my other Formulas as they were displaying the '#VALUE!' error message i discovered that i didn't apply the COUNTIF on some functions after my ',AND' function. Here is one of them;

    Please Login or Register  to view this content.

    As you can probably see, half way through i have;

    Please Login or Register  to view this content.
    Obviously the part '$AA$1=$AA$71:$AA$77' is just wrong and i know i have to wrap this using the COUNTIF function again.


    How do i achieve this in the second part of the code?


    Many thanks for looking and taking the time to help me guys! Any help greatly appreciated!

  2. #2
    Forum Expert leelnich's Avatar
    Join Date
    03-20-2017
    Location
    Delaware, USA
    MS-Off Ver
    Office 2016
    Posts
    2,807

    Re: Adding a COUNTIF function to an existing IF AND COUNTIF Formula...

    You have a lot of duplicate conditions. Perhaps re-arrange OR , AND:
    Please Login or Register  to view this content.
    Last edited by leelnich; 03-24-2018 at 10:07 AM.
    Clicking the Add Reputation star below helpful posts is a great way to show your appreciation.
    Please mark your threads as SOLVED upon conclusion (Thread Tools above Post # 1). - Lee

  3. #3
    Forum Contributor
    Join Date
    02-09-2016
    Location
    West Midlands
    MS-Off Ver
    2016
    Posts
    224

    Re: Adding a COUNTIF function to an existing IF AND COUNTIF Formula...

    Please Login or Register  to view this content.
    like that???

    or with extra bracket before the second AND? like;

    Please Login or Register  to view this content.

  4. #4
    Forum Expert leelnich's Avatar
    Join Date
    03-20-2017
    Location
    Delaware, USA
    MS-Off Ver
    Office 2016
    Posts
    2,807

    Re: Adding a COUNTIF function to an existing IF AND COUNTIF Formula...

    I'm not sure what you're trying to accomplish, as the 2 AND clauses are almost identical. Does this work?:
    Please Login or Register  to view this content.

+ 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] Adding an AND Function to a =IF(COUNTIF.... Formula
    By Ourkid123uk in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-30-2017, 11:51 AM
  2. [SOLVED] CountIf function ... adding another variable
    By Busjedwa30 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 04-01-2015, 07:48 AM
  3. [SOLVED] Sum product or countif function when adding up multi data across a whole table
    By b16dlg in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-29-2013, 03:12 AM
  4. Adding a countIf function into column B if A has data
    By synergio in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-17-2012, 11:13 AM
  5. Count and Countif within existing formula
    By chloesnowling in forum Excel General
    Replies: 1
    Last Post: 01-05-2012, 09:40 AM
  6. Adding a CountIF to a formula that is already Countif
    By Cmorgan in forum Excel General
    Replies: 4
    Last Post: 06-01-2011, 09:34 AM
  7. [SOLVED] existing unique value formula help (index(match(countif)))
    By [email protected] in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-12-2006, 04:40 PM

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