=SUMIFS实际回款金额!II实际回款金额!EEE9实际回款金额!AA&20221+SUMIFS实际回款金额!II实际回款金额!EEE10实际回款金额!AA&20221

This formula calculates the total amount of actual payments received, for two different customers (E9 and E10), before the year 2022. The formula uses the SUMIFS function, which allows the user to specify multiple criteria for summing a range of values.

The first argument of the formula is the range of actual payment amounts (column I) in the sheet "实际回款金额". The second argument specifies the criteria for summing the values in column I: the customer name in column E must match either "E9" or "E10", and the payment date in column A must be before the year 2022.

The formula multiplies the sum of actual payments by 1%, which is equivalent to dividing by 100. This converts the payment amounts from yuan to percent. The formula uses the "+" operator to add the two results together, giving the total amount of actual payments received for both customers.