Help with SUM, SUMIF(S)

Good Morning! I'm needing help coming up with the right formula. Here's my data:

The formula I'm currently using under [Total Breakfasts] is =Sum([Meals-Walk Up]@row,[Meals-Curbside]@row). I want to add a portion to this formula that Breakfasts served on [Day] Thursday are doubled. I know this would probably include a SUMIF formula but I'm not quite sure how to put these to formulas together. The [Total Breakfast] column should be 4@row1, 16@row2 (because they're double on Thursdays) and 4@row3. Maybe this should be a SUMIFS Formula?

Thank you so much for your help!

Best Answer

  • Heather Duff
    Heather Duff ✭✭✭✭✭✭
    Answer ✓

    Hi Autumn,

    Try this:

    =if(day@row="Thursday",2*(Sum([Meals-Walk Up]@row,[Meals-Curbside]@row)),Sum([Meals-Walk Up]@row,[Meals-Curbside]@row))

    This translates to if the day is listed as Thursday, double the sum of (walk up + curbside). If not, show the sum of (walk up + curbside).

    Let me know if it works for you!




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!