Sumif with a date range

Lori CrossLori Cross ✭✭✭✭✭
01/13/21
Accepted

I am trying to calculate the billing amount for an individual month when there are multiple months in the column. Below will calculate all of the billing, but I want to call out 11/2020, 12/2020, 1/2021. What can I add?

=SUMIF({Monthly Detail Range 1}, [Primary Column]@row, {Monthly Detail Range 2})

Best Answer

  • Paul NewcomePaul Newcome ✭✭✭✭✭
    Accepted Answer

    In that case you will need to add an additional range.

    =SUMIFS({Column to Sum}, {Role Column}, [Primary Column]@row, {Date Column}, AND(IFERROR(YEAR(@cell), 0) = 2020, IFERROR(MONTH(@cell), 0) = 11))

Answers

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    You can replace the year and month text in the below with cell references or another year and month function if needed, but here is the general idea...


    =SUMIFS({Column to Sum}, {Date Column}, AND(IFERROR(YEAR(@cell), 0) = 2020, IFERROR(MONTH(@cell), 0) = 11))

  • Lori CrossLori Cross ✭✭✭✭✭

    =SUMIFS({Monthly Detail Range 2}, [Primary Column]@row, {Monthly Detail Range 3}, AND(IFERROR(YEAR(@cell), 0) = 2020, IFERROR(MONTH(@cell), 0) = 11))

    Is coming back as an error #INCORRECT ARGUMENT SET

    Thoughts?

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    That is because of you [Primary Column]@row reference. What is that referring to?

  • Lori CrossLori Cross ✭✭✭✭✭

    I want to separate by roles

Sign In or Register to comment.