=SumIf(range, criteria, sum_range)




SUMIF - Sums the values in a range if they meet a certain 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-2016, LQSystems,Inc. All rights reserved.


   Printer Friendly Page


Home