Formula question for Month Data

I need some help figuring out a formula. Wanting to sum up the amount of trainings each person enrolled in the month of April. Can't seem to figure it out.


Here is what I am trying:

=SUMIF([Trainings/KPL]:[Trainings/KPL], [Assigned OBC]:[Assigned OBC], "Gladys Risling", ([Start Date]:[Start Date], MONTH(@cell)4)

Tags:

Best Answer

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓

    Hi @Gigi_Ris

    It looks like there are a few small updates that you may need to do.

    1. Change SUMIF to be plural, SUMIFS as @BullandKhmer suggested
    2. Take away the extra parentheses before your "start date" reference
    3. Ensure you say that the month equals 4, like so: MONTH(@cell) = 4

    Try this:

    =SUMIFS([Trainings/KPL]:[Trainings/KPL], [Assigned OBC]:[Assigned OBC], "Gladys Risling", [Start Date]:[Start Date], MONTH(@cell) = 4)


    I would also suggest wrapping an IFERROR around that month function in case you have blank cells or cells with text:

    =SUMIFS([Trainings/KPL]:[Trainings/KPL], [Assigned OBC]:[Assigned OBC], "Gladys Risling", [Start Date]:[Start Date], IFERROR(MONTH(@cell), 0) = 4)

    Cheers,

    Genevieve

Answers

  • BullandKhmer
    BullandKhmer ✭✭✭✭✭

    =SUMIFS([Trainings/KPL]:[Trainings/KPL], [Assigned OBC]:[Assigned OBC], "Gladys Risling", ([Start Date]:[Start Date], MONTH(@cell)4)

  • Gigi_Ris
    Gigi_Ris ✭✭✭

    Tried that formula it says unparseable

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓

    Hi @Gigi_Ris

    It looks like there are a few small updates that you may need to do.

    1. Change SUMIF to be plural, SUMIFS as @BullandKhmer suggested
    2. Take away the extra parentheses before your "start date" reference
    3. Ensure you say that the month equals 4, like so: MONTH(@cell) = 4

    Try this:

    =SUMIFS([Trainings/KPL]:[Trainings/KPL], [Assigned OBC]:[Assigned OBC], "Gladys Risling", [Start Date]:[Start Date], MONTH(@cell) = 4)


    I would also suggest wrapping an IFERROR around that month function in case you have blank cells or cells with text:

    =SUMIFS([Trainings/KPL]:[Trainings/KPL], [Assigned OBC]:[Assigned OBC], "Gladys Risling", [Start Date]:[Start Date], IFERROR(MONTH(@cell), 0) = 4)

    Cheers,

    Genevieve

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!