Creating a Sum for multipl

  • Thread starter Thread starter smiley61799
  • Start date Start date
S

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?
 
smiley61799 said:
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?
Click to expand...


Use SUMIF.
 
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
 
Back
Top