+ Reply to Thread
Results 1 to 6 of 6

Countifs range should change dynamically with user input

  1. #1
    Registered User
    Join Date
    03-08-2015
    Location
    Chennai, India
    MS-Off Ver
    2007
    Posts
    28

    Countifs range should change dynamically with user input

    Dear genius I need help from you. Here I have attached my excel sheet, we have 4 Labour camp and we arrange food from outside breakfast lunch and dinner as per the request from workers required food will change for the company I need to send details in abstract and detailed when I want to check any date I need to get summary. Under the list there is summary when I change the date and the food session I need to get the details

    Thanks a lot
    Attached Files Attached Files
    Last edited by AliGW; 04-08-2020 at 05:26 PM. Reason: Request fir urgent attention removed. All posts are treated equally here.

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,577

    Re: Countifs range should change dynamically with user input

    One of possible options:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    and copy down. copy also to next columns with "yes".
    Similar for "no" columns:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Instead of deducting 4 from 3*firstMatch (as there are 3 columns for each date) + second match (to calculate the offset by the meal type) one could use column 4 left from E as a reference. So for "yes":
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Best Regards,

    Kaper

  3. #3
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,577

    Re: Countifs range should change dynamically with user input

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. In other your thread I've shown how to do it.

    Also, as a relatively not frequent user of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

  4. #4
    Forum Expert BMV's Avatar
    Join Date
    01-13-2020
    Location
    St-Petersburg, Russia
    MS-Off Ver
    2013-2016
    Posts
    1,329

    Re: Countifs range should change dynamically with user input

    non volatile
    Please Login or Register  to view this content.

  5. #5
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Countifs range should change dynamically with user input

    Please try at E56
    =COUNTIFS($A$3:$A$50,$D56,$D$3:$D$50,LOOKUP("z",$E$54:E$54),INDEX($D$3:$CP$50,,MATCH($E$53,$E$1:$CP$1)+MATCH($M$53,$E$2:$G$2,)),E$55)
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    03-08-2015
    Location
    Chennai, India
    MS-Off Ver
    2007
    Posts
    28

    Re: Countifs range should change dynamically with user input

    Thanks a lot

+ 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. Dynamically change formula range
    By 119luke in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-29-2018, 01:44 PM
  2. [SOLVED] Change set workbook name from User input
    By bigroo1958 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-16-2018, 01:23 PM
  3. Replies: 3
    Last Post: 06-28-2016, 04:24 AM
  4. Change event to Convert (calculate) user input if user types % sign
    By soundneedle in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-18-2016, 12:01 PM
  5. [SOLVED] Trying to change a user input string
    By mrpwebb in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-19-2014, 10:19 AM
  6. Dynamically create user form with text-box's from range
    By zhb12810 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-10-2013, 10:31 AM
  7. How to change Pivot Range dynamically(Macro)
    By leninbabu in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-09-2009, 06:38 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