LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 17
Default 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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
creating Yes,No Amin Excel Discussion (Misc queries) 3 November 8th 08 10:02 PM
Paste HTML w/Multipl css classes James Carman Excel Discussion (Misc queries) 0 May 9th 08 04:47 PM
multipl HLOOKUP/VLOOKUP Criteria Jonathan Horvath Excel Discussion (Misc queries) 3 December 15th 06 04:50 PM
Return single value on multipl criteria lookup maplesugarsnow Excel Worksheet Functions 3 July 1st 06 01:03 PM
Multipl IF Statements - REVISION vnsrod2000 Excel Worksheet Functions 1 February 4th 05 08:22 PM


All times are GMT +1. The time now is 07:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"