Thread: excel
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
smason smason is offline
external usenet poster
 
Posts: 10
Default excel

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