SUMIFS Reference Formula with two date columns and one condition. Formula is computing 0

Brendan Ginns

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

Paul Newcome

You are basically saying to sum rows where the start date and end date both are within January 2024.

Brendan Ginns

yes correct, and it will be adjustable for the next condition of February, etc

Paul Newcome

Can you show some rows from the source data that you would expect to have calculated?