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
 All Categories
 14 Welcome to the Community
 10.6K Get Help
 63 Global Discussions
 46 Industry Talk
 387 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 466 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!