# Sumif Function, Sumif Syntax, Sumif Examples

__Finally__, we copy the formula to cells F10-F13. Select cell F9,
use key combination Ctrl+C to copy the formula, then select cells F10-F13
and use key combination Ctrl+V to paste the formula:

The result is what we wanted - the list of fixed assets classes with their respective costs.

### 3) Sumif example #2: Summarize cost of fixed assets over a certain limit using SUMIF

Sometimes we want to summarize costs over a certain amount. For example,
using the data from the above example, we may want to know the total value
of all fixed assets with costs of more than $200,000. In this case, we
can again use **SUMIF function**.

Recall that the criteria may be a number, expression or text. Expression is what we will use to accomplish the task in this example:

=SUMIF ( $C$9:$C$179, ">200000" ), where

- $C$9:$C$179 is
*range* - ">200000" is
*criteria*.

The third argument, *sum_range*, is omitted from the formula.
That is because if *sum_range* is omitted, the cells in *range
*are evaluated against the criteria and summed. So, cells C9-C179
serve as the *range *and the *sum_range* at the same time
in the above formula:

The result of the formula shows that the total of all fixed assets with individual costs of more than $200,000 is 13,582,795.02.

You can also use less than ("<") if you need to summarize fixed assets under a certain amount.

Page 3 of 3