SUMIFS question regarding multiple criteria to summarize a cost column

I have two sheets I am using, one is my master sheet where I am collecting this information via form I created and the second sheet is what I like to call my data sheet.

I got the formula down for if it's domestic or international, then calculate the sum. That's perfect. But I am trying to further break it up by month and have been struggling with the formula. Keep in mind the {} is because I am referencing another sheet.

I cant seem to get it to work for calculating the sum of {Cost} if it's International AND April. Any suggestions for my formula?

Find more posts tagged with

Formulas

Accepted answers

Ryan Sides

Hi there, your cost should be the first piece of the formula if that's what you're trying to sum up.

=sumifs({Cost}, {Dom or Int}, "International", {Month}, "April")

All comments

Ryan Sides

Hi there, your cost should be the first piece of the formula if that's what you're trying to sum up.

=sumifs({Cost}, {Dom or Int}, "International", {Month}, "April")

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.