SUMIFS Question for adding a criteria for a column sum function

Hello! I am working on creating a travel budget dashboard for my team. I threw in some random numbers but essentially I am creating this data sheet to reference my main sheet where I house all travel budget requests.

In my other sheet I treat as a data repository of all requests I receive. The above {cost} and {Dom or Int} is referencing a different sheet.

In that "international cost" above I am trying to get the cost sum of anything that is marked as domestic in my other sheet. Am I messing up the formula?

Any feedback would be greatly appreciated!

Find more posts tagged with

Formulas

Accepted answers

All comments

Austin Smith

@lovelyemy

Make sure the reference word is in quotes (only error I see, if it's even an error given sample status). You can use, but don't need, a sumifs with only one qualifier (formula is generally correct though). Try formula below.

=SUMIF([Domestic or international]:[Domestic or international], "Domestic", Cost:Cost)

All references can come from original data sheet.

What error are you getting from the formula?

lovelyemy

https://community.smartsheet.com/discussion/comment/370994#Comment_370994

Hi there, I am actually referencing a separate sheet that's why I called it {Dom or Int} for the Domestic or International Column using the reference another sheet link. I just gave this a shot and am getting the #UNPARSEABLE error message.

Austin Smith

@lovelyemy

Typically #unparseable has to do with your reference data having something in it that doesn't compute. Can you run a sum formula for costing inside of the origin sheet without errors?

BullandKhmer

Hey,

I'm too lazy to figure out all the details, but it seems that your syntax is wrong. When you cross reference a column in another sheet you dont use {name}:{name}, the reference is just {name}.

Also, when you want to use SUMIF and = a word, you need to put that word in quotations. "word".

I'm writing this whilst referencing your first screenshot.

If you make these adjustments your SUMIF formula will work.

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.