SUM DISTINCT Cross Reference Sheet

Hello,

I'm attempting to perform a sum on a value from another sheet. We've got multiple teammates that charge to varying different funding sources, but I want to sum based on the funding source type. I've attempted to use the formula below, but I'm getting an Invalid Data type. I've checked the source and target columns to make sure they're 'Text/Number' columns, but no luck. Any advice is appreciated.

=SUM(DISTINCT({FY Forecasts Funding Source}, {FY Forecasted Spend}, "funding source type"))

Find more posts tagged with

Accepted answers

Jason Voorhies

@Adam Murphy I can't express my gratitude for the help. As you can probably guess I'm only recently ramping up my Smartsheet skills. I seem to get stuck on the simply bits…

Used what you suggested but it returned $0.00, so I tried this and got some results back (this goes to your assumption which was reversed):

=SUMIF({FY Forecasts Funding Source}, "SDMP", {FY Forecasted Spend})

You rock! Appreciate the assist!

All comments

Adam Murphy

Hi Jason, try =SUMIF({FY Forecasted Spend}, "funding source type", {FY Forecasts Funding Source}) which assumes that FY Forecasted Spend would contain "funding source type" and FY Forecasts Funding Source would contain the value you want to add. Hope this helps!

Jason Voorhies

@Adam Murphy I can't express my gratitude for the help. As you can probably guess I'm only recently ramping up my Smartsheet skills. I seem to get stuck on the simply bits…

You rock! Appreciate the assist!

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.