excel

S

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
 
T

Tim879

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

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

edvwvw via OfficeKB.com

Try the following


=SUMIF(B1:B3,"bb01",A1:A3)

this will give the desired result

edvwvw
 
Top