One way to find the sum of order IDs that contain both PRODUCT 1 and PRODUCT 2 using an excel formula is to use the SUMIFS function. The syntax for this formula would be:
=SUMIFS(range of cells to sum, range of cells to check for PRODUCT 1, "PRODUCT 1", range of cells to check for PRODUCT 2, "PRODUCT 2")
For example, if the range of cells to sum is B2:B10, the range of cells to check for PRODUCT 1 is A2:A10, and the range of cells to check for PRODUCT 2 is C2:C10, the formula would be:
=SUMIFS(B2:B10, A2:A10, "PRODUCT 1", C2:C10, "PRODUCT 2")