=SumIf(range, criteria, sum_range)
SUMIF - Sums the values in a range if they meet a certain criteria.
Range
Range of cells to be compared to the CRITERIA.
Criteria
Expression for testing the cells in the RANGE.
Sum_range
The cells to be summed.
(These matched the criteria).
If SUM_RANGE is left out, the cells in RANGE are summed.
Example 1:
|
A |
B |
C |
1 |
VALUE |
|
REBATE |
2 |
$100 |
|
$10.00 |
3 |
$500 |
|
$20.00 |
4 |
$1000 |
|
$25.00 |
5 |
$1500 |
|
$35.00 |
6 |
|
|
|
7 |
= SUMIF(A2:A5, ">700.00", C2:C5) |
|
This Formula will sum the values in range
C2:C5 where the values in
A2:A5 are greater than $700.00.
In this example, the values in
A4 and
A5 meet the criteria, so the values in
C4 and
C5 are summed.
The formula will return the value
$60.00.
Copyright © 2006-2019, LQSystems,Inc. All rights reserved.