Скачать или смотреть Excel Efficiency Lab - The SUMIF Function

The SUMIF function allows us to total only the rows that meet a specific condition.

Here, we’re tracking sales by region. If we want total sales from the East region, the formula in cell C12 is:
=SUMIF(A2:A9, "East", C2:C9)

This tells Excel to look in column A for ‘East’ and add only the matching values in column C. Perfect for quick, filtered totals.”

We can also utilize other cells for the criteria, in our example we use cell B13 (West) as the criteria.

We can lock the reference to the cell by pressing F4, this will show $ before the column and row indicators. When copying and pasting the reference will remain set the data from the original formulated cell.