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.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!