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