Home |
Search |
Today's Posts |
#1
|
|||
|
|||
SUMIF
I'm trying to sum column two, if column one
meets condition.... weeks tons 2 6.8 6 23.7 7 28.6 4 36.2 8 24.2 8 24.2 6 26.4 6 12.2 2 23.5 IF column 1 =2, sum column 2...... -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...l-new/200508/1 |
#2
|
|||
|
|||
Use the SUMIF function. E.g.,
=SUMIF(A1:A10,8,B1:B10) "jeremy via OfficeKB.com" wrote in message ... I'm trying to sum column two, if column one meets condition.... weeks tons 2 6.8 6 23.7 7 28.6 4 36.2 8 24.2 8 24.2 6 26.4 6 12.2 2 23.5 IF column 1 =2, sum column 2...... -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...l-new/200508/1 |
#3
|
|||
|
|||
You can "hard code" the "2" into the formula itself:
=SUMIF(A2:A10,2,B2:B10) OR You could assign a cell to contain the number to match, so that you could easily change it without having to change the formula itself: =SUMIF(A2:A10,C1,B2:B10) With C1 designated as the cell to contain the number to match. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "jeremy via OfficeKB.com" wrote in message ... I'm trying to sum column two, if column one meets condition.... weeks tons 2 6.8 6 23.7 7 28.6 4 36.2 8 24.2 8 24.2 6 26.4 6 12.2 2 23.5 IF column 1 =2, sum column 2...... -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...l-new/200508/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to use SUMIF to return sums between two values located in cells | Excel Worksheet Functions | |||
SUMIF with Mutiple Ranges & Criteria | Excel Discussion (Misc queries) | |||
Dynamic sumif function | Excel Worksheet Functions | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions | |||
SUM(IF( Array to avoid #NUM! values | Excel Worksheet Functions |