SUMIF function with multiple criteria from a data list to get orders and returns!

[jrich16]

This is continuing post from: excelforum.com/excel-formulas-and-functions/1420319-sumif-fuctioin-with-mutliple-criterias-from-a-data-list-new-post.html

I made some mistakes there like going over the 20-line data limit and not puting in the solution I was looking for! I posted it from JPRICH16 but cant access that account so made a new one! sorry for the long explanation!!

Below is the exact post (new excel attachment)

"Hi Everyone,

I need returns and orders from a specific customer.

Orders is easy its: =SUMIFS(Data!$G:$G,Data!$D:$D,"Order",Data!$J:$J,Sheet2!$I$6,Data!$V:$V,">10/1/2023")

So returns should be: =SUMIFS(Data!$G:$G,Data!$D:$D,"Return",Data!$J:$J,Sheet2!$I$6,Data!$V:$V,">10/1/2023")

BUT

A return can only be true IF the serial number being returned has been ORDERED AFTER the start date, in this case, 10/1/2023.

Since the data can go back YEARS, i need to a formula search all return serial numbers that have an order date that is after the start date And had the same serial number.....or its overstated and wrong

i cant figure it out!!!!"