Sub total

[Rasoul Khoshravan]

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]

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

 

[Sandy]

Try using the SumIf...

 

[Sandy]

Try using the SumIf function...

Sandy

 

[Tarig]

Thanks for your help, I have used successfully sumif command