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

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

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

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


On May 22, 10:10 am, smason wrote:
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

thanks works a treat

"Tim879" wrote:

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

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


On May 22, 10:10 am, smason wrote:
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

Try the following


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

this will give the desired result

edvwvw

smason wrote:
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

--
Message posted via http://www.officekb.com