SUMIF(Reference Sheet) YTD

Good evening, I have been battling this one for a few days and think its time to ask for help...

The goal is to SUMIF a column from another sheet is within YTD. This is where I am with it:

=SUMIF({Reference_Sheet_Column_A}, {Same_Reference_Sheet_Diff_Column_With_Dates}@cell, AND(@cell >= DATE(YEAR(TODAY()), 1, 1), @cell <= TODAY()))

Any help is appreciated

Find more posts tagged with

Accepted answers

TVang

Assuming {Reference_Sheet_Column_A} is what you're trying to add, then try...

=SUMIF({Same_Reference_Sheet_Diff_Column_With_Dates}, AND(@cell >= DATE(YEAR(TODAY()), 1, 1), @cell <= TODAY()), {Reference_Sheet_Column_A})

The syntax for SUMIF() is SUMIF( range, criterion, [ sum_range]).

In the formula above:

The range to evaluate is {Same_Reference_Sheet_Diff_Column_With_Dates}.
The criterion is AND(@cell >= DATE(YEAR(TODAY()), 1, 1), @cell <= TODAY()) .
The range to sum is {Reference_Sheet_Column_A} .

All comments

TVang

Assuming {Reference_Sheet_Column_A} is what you're trying to add, then try...

=SUMIF({Same_Reference_Sheet_Diff_Column_With_Dates}, AND(@cell >= DATE(YEAR(TODAY()), 1, 1), @cell <= TODAY()), {Reference_Sheet_Column_A})

The syntax for SUMIF() is SUMIF( range, criterion, [ sum_range]).

In the formula above:

The range to evaluate is {Same_Reference_Sheet_Diff_Column_With_Dates}.
The criterion is AND(@cell >= DATE(YEAR(TODAY()), 1, 1), @cell <= TODAY()) .
The range to sum is {Reference_Sheet_Column_A} .

J Smith

Oh wow, I had it backwards! Thank you so much. I did have to make a few tweaks, but it worked!

=SUMIF({Source_Sheet_With_Dates}, AND(@cell >= DATE(YEAR(TODAY()), 1, 1), (@cell <= TODAY())), {Same_Sheet_Column_to_Sum})

This exact formula worked

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.