In WPS, sum sales in D where region is 华东 and month is 2024-03

公式

=SUMIFS(D:D, A:A, "华东", B:B, "2024-03")

说明

WPS implements SUMIFS with comma separators the same way Excel does. Stick to SUMIFS/VLOOKUP/INDEX rather than Excel 365-only functions like FILTER.

步骤

  1. D:D is the sum range.
  2. A:A equals 华东.
  3. B:B equals 2024-03 (or a real date — keep types consistent).

变体

Single-criterion SUMIF

Use when you only need one test.

=SUMIF(A:A, "华东", D:D)

Numeric month from a date column

When column B stores real dates instead of 2024-03 text.

=SUMPRODUCT((A2:A500="华东")*(MONTH(B2:B500)=3)*(YEAR(B2:B500)=2024), D2:D500)

COUNTIFS counterpart

How many orders, not the amount.

=COUNTIFS(A:A, "华东", B:B, "2024-03")