Hi,
I have attached a modified file containing a solution.
An extra column (column D) was added to the "Returns April - June" sheet and in that column the value "returned" was entered is each row.
also an extra column (column D) was added to the "April Orders" sheet and that column the VLOOKUP is used to call up a "returned" value from the "Returns April - June" sheet based on the Order ID. So, only orders made in April (from the April Orders sheet) will have a value of "returned" in column D. In order to make it tidy, the VLOOKUP function was nested in an IFERROR function to display "not returned" for orders that did not originate in April or were not returned by a customer, else the #N/A error will be displayed in column D.
Finally, the SUMIFS function was used to sum up the orders made in only April but returned in April - June.
|