Creating a Sum for multipl
 

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?

Creating a Sum for multipl
 

"smiley61799" wrote in message
...
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.

--
Asking a question?
Please tell us the version of the application you are asking about,
your OS, Service Pack level
and the FULL contents of any error message(s)

Creating a Sum for multipl
 

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

"smiley61799" wrote:

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?