Look in the help index for SUMIF
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"smason" wrote in message
...
Hello i have aspread sheet which contains two columns example


amount code
100 bb01
200 cc02
300 bb01
what i would like to do is calcutlate all the cells (amount ) where the
code
is bb01 for example and get the total 400