SUMIFS in last 60 days.

Chris Benskin

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.

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