Sum of total pend per Quarter

Options
Max Ahmed
Max Ahmed ✭✭✭✭
edited 06/28/22 in Formulas and Functions

What's wrong with Formula?

Best Answer

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓
    Options

    Hi @Max Ahmed

    Ah my apologies! Since we're using SUMIFS in this instance, you'll want to have the column to SUM be the first range, not the last.

    Try:

    =SUMIFS({Pipeline-Remodel Completion Dates cost}, {Pipeline-Remodel Completion Dates Start}, >=Date(2021, 4, 1), {Pipeline-Remodel Completion Dates Start}, <=Date(2021, 7, 31))

Answers

  • Genevieve P.
    Genevieve P. Employee Admin
    Options

    Hi @Max Ahmed

    If you're looking for multiple criteria in a SUMIF, you'll want to use SUMIFS (plural) instead. With a SUMIFS, the column to SUM is actually the last range that you list. See: SUMIFS Function

    Try:

    =SUMIFS({Remodel Pipeline Big Picture Summary Range 1}, >=DATE(2021, 4, 1), {Remodel Pipeline Big Picture Summary Range 1}, <=DATE(2021, 7, 31), {Pipeline-Remodel Range 3})


    Note that both {Remodel Pipeline Big Picture Summary Range 1} and {Pipeline-Remodel Range 3} will need to be looking at the same sheet.

    Let me know if this has resolved your issue!

    Cheers,

    Genevieve

  • Max Ahmed
    Max Ahmed ✭✭✭✭
    Options

    I think the Problem is that they are separate sheets. I have tried sumifs with the formula before. Let me amend it to the same sheet and see if i get a result

  • Max Ahmed
    Max Ahmed ✭✭✭✭
    Options

    Still Getting invalid Operation


  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓
    Options

    Hi @Max Ahmed

    Ah my apologies! Since we're using SUMIFS in this instance, you'll want to have the column to SUM be the first range, not the last.

    Try:

    =SUMIFS({Pipeline-Remodel Completion Dates cost}, {Pipeline-Remodel Completion Dates Start}, >=Date(2021, 4, 1), {Pipeline-Remodel Completion Dates Start}, <=Date(2021, 7, 31))

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!