Help with SUM, SUMIF(S)

Options

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!

• ✭✭✭✭✭✭
Options

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!

Best,

Heather

• ✭✭✭✭✭✭
Options

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!

Best,

Heather

• Options

This is amazing. It worked perfectly! Thank you so much!

• ✭✭✭✭✭✭
Options

Glad it worked. Happy to help!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!