Count IF between certain dates on different sheets
Hello All,
I am looking for an overall count of items that came in during the week. (Example: anything "Date Added" 2024, 3, 4 through 2024, 3, 8). Some of the items do get archived onto another sheet if other criteria are met.
Have been trying a variety of formulas but have been unsuccessful. Any help?
Thank you all
Answers
-
Hi @munoz_rita,
please try the following,Assuming you have a column named "Date Added" where the dates are recorded, you can use the following formula to count the items added between March 4, 2024, and March 8, 2024, inclusive:
=COUNTIFS([Date Added]:[Date Added], >=DATE(2024, 3, 4), [Date Added]:[Date Added], <=DATE(2024, 3, 8))
Here's a breakdown of the formula:
COUNTIFS
is the function used to count the number of cells that meet a set of criteria.[Date Added]:[Date Added]
specifies the range to check for the criteria. Replace[Date Added]
with the actual name of your column if it's different.>=DATE(2024, 3, 4)
is the first criterion. It checks for dates that are greater than or equal to March 4, 2024.<=DATE(2024, 3, 8)
is the second criterion. It checks for dates that are less than or equal to March 8, 2024.
This formula will count all rows where the "Date Added" is within the specified week.
If your items can get archived onto another sheet and you want to include those in your count as well, you'll need to ensure that the archived items have their "Date Added" recorded in a similar manner and then either: Apply the same formula in the archive sheet and sum the results from both sheets.
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!