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([MealsWalk Up]@row,[MealsCurbside]@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

Hi Autumn,
Try this:
=if(day@row="Thursday",2*(Sum([MealsWalk Up]@row,[MealsCurbside]@row)),Sum([MealsWalk Up]@row,[MealsCurbside]@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
Answers

Hi Autumn,
Try this:
=if(day@row="Thursday",2*(Sum([MealsWalk Up]@row,[MealsCurbside]@row)),Sum([MealsWalk Up]@row,[MealsCurbside]@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

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

Glad it worked. Happy to help!
Help Article Resources
Categories
Check out the Formula Handbook template!