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