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

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!