+ Reply to Thread
Results 1 to 7 of 7

if statement with countifs statement with two variables

  1. 09-11-2018, 12:59 AM #1
    quentin5000
    quentin5000 is offline
    Registered User
    Join Date
    10-14-2015
    Location
    Perth
    MS-Off Ver
    2010
    Posts
    58

    if statement with countifs statement with two variables

    Hi all

    I hope someone can help me, I am wanting to write an IF statement where by if a count of a term appears over 7 times or more in a single month, then the IF formula should calculate certain way. If the total count for a particular word is less than 7, than the IF formula shall calculate a different way. This formula would have to then be reset for each subsequent month. I hope this makes sense, I have provided a simple example worksheet to clarify.

    Thank you all
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 09-11-2018, 01:08 AM #2
    FlameRetired
    FlameRetired is offline
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: if statement with countifs statement with two variables

    Withdrawn by FR. Found clarification further down.
    Last edited by FlameRetired; 09-11-2018 at 01:11 AM.
    Dave
    Reply With QuoteRegister To Reply
  3. 09-11-2018, 01:11 AM #3
    shukla.ankur281190
    shukla.ankur281190 is offline
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,937

    Re: if statement with countifs statement with two variables

    Try

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


    Copy down!
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Reply With QuoteRegister To Reply
  4. 09-11-2018, 01:24 AM #4
    quentin5000
    quentin5000 is offline
    Registered User
    Join Date
    10-14-2015
    Location
    Perth
    MS-Off Ver
    2010
    Posts
    58

    Re: if statement with countifs statement with two variables

    Hi

    Thanks for the the quick response!

    I have tried it and it definitely works. I will add this to my formula and make sure it works.

    Thanks again
    Reply With QuoteRegister To Reply
  5. 09-11-2018, 01:29 AM #5
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,916

    Re: if statement with countifs statement with two variables

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  6. 09-11-2018, 01:35 AM #6
    FlameRetired
    FlameRetired is offline
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: if statement with countifs statement with two variables

    In the attached there is a lookup table that defines lower and upper boundaries of each month. Formulas are
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    and
    Formula: copy to clipboard 
    Please Login or Register  to view this content.


    In D2 and down
    Formula: copy to clipboard 
    Please Login or Register  to view this content.


    Edit I believe row 20 should also be double.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  7. 09-20-2018, 08:42 PM #7
    quentin5000
    quentin5000 is offline
    Registered User
    Join Date
    10-14-2015
    Location
    Perth
    MS-Off Ver
    2010
    Posts
    58

    Re: if statement with countifs statement with two variables

    Hi

    Thank you all for your posts.

    Apologies for my delay in responding. Shukla thank you, your countif formula works. To make it work with my calculations I included it as part of of my AND statement. The calculations I have in there are a little more complicated than the example calculation I provided so I had to tweak it a bit.

    FlameRetired apologies I didn't try your formula.

    I will now mark this forum solved.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Countifs statement help
    By Alaskan_grunt in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-05-2016, 09:39 PM
  2. Or within Countifs statement
    By blens1 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-20-2014, 10:22 PM
  3. [SOLVED] help nesting OR statement into COUNTIFS statement
    By HeyInKy in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-18-2014, 09:31 AM
  4. [SOLVED] =COUNTIFS statement
    By Glen- in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-09-2014, 10:49 AM
  5. [SOLVED] Problem in COUNTIFS statement
    By abduljaleel.mca in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-13-2013, 02:32 AM
  6. Or function within a countifs statement
    By transitsolutions in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-01-2013, 02:38 PM
  7. Countifs Statement
    By turpink in forum Excel General
    Replies: 1
    Last Post: 09-12-2011, 01:01 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1