Creating a Sum for multipl

[smiley61799]

I have a spread sheet for services which are bnroken down in one column as
Discounted or Standard. I have been asked to create a sum formula which is
able to identify whether the line is for a Discounted item or a Standard Item
and sum accordingly. EX:

Cloumn A Column B Column C
Discount Desc. 1 25
Standard Desc. 1 50
Standard Desc. 2 60
Discount Desc. 2 30

Sum of all discounted items =
Sum of all Standard Items =

Is there a way to sum based off Column A's description?

 

[Gordon]

I have a spread sheet for services which are bnroken down in one column as
Discounted or Standard. I have been asked to create a sum formula which
is
able to identify whether the line is for a Discounted item or a Standard
Item
and sum accordingly. EX:

Cloumn A Column B Column C
Discount Desc. 1 25
Standard Desc. 1 50
Standard Desc. 2 60
Discount Desc. 2 30

Sum of all discounted items =
Sum of all Standard Items =

Is there a way to sum based off Column A's description?

Use SUMIF.

 

[Eduardo]

Hi,

Hi,
Let's say that you want to summarize Discount in D1 and Standard in D2
In cell E1 enter

=sumproduct(--(D1=$A$1:$A$100),$C$1:$C$100) and copy this into D2

Change the range of A and C to fit your needs, be aware that both ranges has
to be exactly the same

If this helped please click yes, thanks