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" 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)

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?