SUMIF

Add values that meet one condition, such as a department or product.

Practical example

=SUMIF(A:A, "Stationery", D:D)

Identify the source cells, apply the smallest reliable formula or tool, and test the result with changed data.