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