excel

[smason]

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

 

[Don Guillett]

Look in the help index for SUMIF

 

[Tim879]

You can use the Sumif formula to do this as follows:

=SUMIF($B$1:$B$3,"bb01",$A$1:$A$3)

 

[smason]

thanks works a treat

You can use the Sumif formula to do this as follows:

=SUMIF($B$1:$B$3,"bb01",$A$1:$A$3)