SUMIFS Reference Formula with two date columns and one condition. Formula is computing 0
Hi can anyone see if they can think of what might be causing this formula to compute 0 and not Summing the {Check In Log Range 1}
{Check In Log Range 1} = Dollar Volume
{Check In Log Range 2} = Employee Condition
{Check In Log Range 3} = Start Date
{Check In Log Range 4} = End Date
=SUMIFS({Check In Log Range 1}, {Check In Log Range 2}, =[Employee ID]@row, {Check In Log Range 3}, AND(@cell >= DATE(2024, 1, 1), @cell <= DATE(2024, 1, 31)), {Check In Log Range 4}, AND(@cell >= DATE(2024, 1, 1), @cell <= DATE(2024, 1, 31)))
Answers
-
You are basically saying to sum rows where the start date and end date both are within January 2024.
-
yes correct, and it will be adjustable for the next condition of February, etc
-
Can you show some rows from the source data that you would expect to have calculated?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!