Sub total

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tarig - 09 Oct 2006 13:21 GMT

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

Reply to this Message

Rasoul Khoshravan - 09 Oct 2006 08:21 GMT

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

>I have a master data sheet that contains reciept numbers in column "A",
> description in column "B" and amount in column "C".
[quoted text clipped - 3 lines]
>
> tarig

Reply to this Message

Tarig - 10 Oct 2006 06:34 GMT

Thanks for your help, I have used successfully sumif command

Signature

tarig elsawi

> Use "sumif" command.
> sumif(range of criteria,critera, the range to bu summed)
[quoted text clipped - 10 lines]
> >
> > tarig

Reply to this Message

Sandy - 09 Oct 2006 14:35 GMT

Try using the SumIf...

Sandy

> I have a master data sheet that contains reciept numbers in column "A",
> description in column "B" and amount in column "C".
[quoted text clipped - 3 lines]
>
> tarig

Reply to this Message

Sandy - 09 Oct 2006 14:38 GMT

Try using the SumIf function...

Sandy

> I have a master data sheet that contains reciept numbers in column "A",
> description in column "B" and amount in column "C".
[quoted text clipped - 3 lines]
>
> tarig

Reply to this Message