SumIf Worksheet Function

by Linda Quinn

Close Window

=SumIf(range, criteria, sum_range)


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.


=================================================================
This content was created by Linda Quinn of LQNet.

See http://www.lqnet.com for a great collection of articles on this and other topics.

=================================================================
Copyright © 2006-2008, LQ Systems,Inc. All rights reserved.


====================================================================
Want an expert to help with your project?    LQ Systems, Inc.   Business Solutions
====================================================================