Adding # of days with in a date range

Kyle Black

this is what i came up with looking at other people i keep getting #invalid operation

=SUMIFS({2021 Sioux City Utility OSHA 300 Form Range 18}, {2021 Sioux City Utility OSHA 300 Form Range 1} <= DATE(2021, 1, 31), {2021 Sioux City Utility OSHA 300 Form Range 1}, >=DATE(2021, 1, 1))

the first range (range 18) is the #number of event days in a month, the second (range 1) is the initial day of the event. I want to add up the days per month per event.

David Tutwiler

Looks to me like you're just missing a command in your SUMIFS formula before the <=. This should work

=SUMIFS({2021 Sioux City Utility OSHA 300 Form Range 18}, {2021 Sioux City Utility OSHA 300 Form Range 1}, <= DATE(2021, 1, 31), {2021 Sioux City Utility OSHA 300 Form Range 1}, >=DATE(2021, 1, 1))

David Tutwiler

Looks to me like you're just missing a command in your SUMIFS formula before the <=. This should work

=SUMIFS({2021 Sioux City Utility OSHA 300 Form Range 18}, {2021 Sioux City Utility OSHA 300 Form Range 1}, <= DATE(2021, 1, 31), {2021 Sioux City Utility OSHA 300 Form Range 1}, >=DATE(2021, 1, 1))

Kyle Black

Thank you!

David Tutwiler

No problem, glad it's working.