Thread: Sub total
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Rasoul Khoshravan Rasoul Khoshravan is offline
external usenet poster
 
Posts: 82
Default Sub total

Use "sumif" command.
sumif(range of criteria,critera, the range to bu summed)
in your case

sumif(column B,"put the discription, you want the sum for them",column C)
HTH

"Tarig" wrote in message
...
I have a master data sheet that contains reciept numbers in column "A",
description in column "B" and amount in column "C".
I need a formulae that can sum amounts with the same similar description.

Thanks in advance


tarig