SUMIF Formula

Nathan Umbriac

I created a form which captures total costs for outsourced activities. If a region selected is "Europe", for example, I want to reference the form sheet to total all 'Europe" costs.

Is SUMIF the correct formula?

Kimberly Loveless

Yes it is the correct function

It will look something like the one below (I can't be certain without knowing the exact column headings you are using)

For formula use in the same sheet it would be:

= SUMIF(Region:Region, "Europe", Costs:Costs)

For formula use in a separate sheet with cross sheet references it would be:

= SUMIF({Region}, "Europe", {Costs})

Kimberly Loveless

Yes it is the correct function

It will look something like the one below (I can't be certain without knowing the exact column headings you are using)

For formula use in the same sheet it would be:

= SUMIF(Region:Region, "Europe", Costs:Costs)

For formula use in a separate sheet with cross sheet references it would be:

= SUMIF({Region}, "Europe", {Costs})

Nathan Umbriac

Thank you, @Kimberly Loveless! This is perfect.