Adding # of days with in a date range

09/21/21
Accepted

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.

Tags:

Best Answer

  • David TutwilerDavid Tutwiler Overachievers
    Accepted Answer

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

Answers

  • David TutwilerDavid Tutwiler Overachievers
    Accepted Answer

    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 BlackKyle Black ✭✭✭✭

    Thank you!

  • David TutwilerDavid Tutwiler Overachievers

    No problem, glad it's working.

Sign In or Register to comment.