Sum values on another sheet based on two columns

Hello, I am attempting to execute the following formula: =SUMIFS({Transfer Amount}, {Transfer Type}, "Recognized", {Month Invoiced}, >=DATE(2022, 1, 1), {Month Invoiced}, <DATE(2022, 2, 1)) where I want to sum values in a column based on a 2nd column's criteria and a 3rd date column range. The formula worked in test sheet but failed on my actual sheet.

Find more posts tagged with

Accepted answers

All comments

Ray Lindstrom

Hi @scott landon,

I can't help but notice there are no outbound arrows on your Transfer Type column cells. Check your cross-sheet references on your destination sheet, and make sure you have one for {Transfer Type}. I believe once that is set, your formula should run properly.

Hope that helps!

BRgds,

-Ray

scott landon

Thank you Ray, my cross reference was correct but apparently it was a synch issue because I came back later with no changes and it was working. Now the arrows appear. Good catch.

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.