# Countifs range should change dynamically with user input

1. ## 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

2. ## Re: Countifs range should change dynamically with user input

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

and copy down. copy also to next columns with "yes".
Similar for "no" columns:
Formula:
`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:
`Please Login or Register  to view this content.`

3. ## Re: Countifs range should change dynamically with user input

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. ## Re: Countifs range should change dynamically with user input

non volatile
``Please Login or Register  to view this content.``

5. ## Re: Countifs range should change dynamically with user input

=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)

6. ## Re: Countifs range should change dynamically with user input

Thanks a lot

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

#### 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