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!

Find more posts tagged with

Accepted answers

Heather Duff

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

All comments

Heather Duff

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

Autumn Montegna

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

Heather Duff

Glad it worked. Happy to help!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.