SUMIFS in last 60 days.

I have a formula that returns the sum of a part number from a different worksheet. It works as it should but I would like to limit what it returns to the last 60 days.

Here is the working formula for summing the part numbers in the other sheet.

=SUMIF({Material Transfer Log Range 2}, @cell = [MIS P/N]@row, {Material Transfer Log Range 1})

Just looking for the right direction in getting it to sum only those parts in the last 60 days.

Thank you in advance for your help.

Find more posts tagged with

Accepted answers

All comments

Bassam Khalil

Hi @Chris Benskin

Hope you are fine, if you have a [submitted on] date column then your formula to get the input in the last 60 date will be:

=SUMIFS({Material Transfer Log Range 2}, @cell = [MIS P/N]@row,
{Material Transfer Log Range 1},{submitted on Range 1},@cell >=today(-60))

Chris Benskin

Bassam

I get an INVALID OPERTATION. Here is the formula I entered based on your input.

Here is {Material Transfer Log Range 3} that I'm getting the dates from. Would the blank cells be causing an issue?

Bassam Khalil

@Chris Benskin

if you like me to fix the formula directly on your sheet please share me as an admin on a sample copy of your sheets ( Source & Destination ) and i will Create the exact formula for you then you can copy it to your original sheet.

My Email for sharing : Bassam.k@mobilproject.it

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.