# 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?

Tags:

• ✭✭✭✭✭✭

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")

Ryan Sides

Come Say Hello!

• ✭✭✭✭✭✭

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")

Ryan Sides