Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / May 2008

Tip: Looking for answers? Try searching our database.

Excel 2007

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
nrodADAA - 06 May 2008 22:03 GMT
I am new to Excel, I have a "for dummies" book but what I need, I have not a
clue where to look.  I have Excel 2007, OS XP.

I have 1000 plus rows of info the columns are titled
A              B          C         D
Amount     Name    State   Code
$50.00      Nancy    IL        Telemarketing
$75.00      Kim       FL        Acquisition    
$25.00      Isabel    TX       Telemarketing
$15.00      Santos   IN        Acquisition

I want to get the sum of column A (dollar amount total) by code
(telemarketing or acquisition), is there a way to do that, and if there is,
what is it called?

I appreciate any help, either how to do this or what it is called so I can
figure out what to look under.
Don Guillett - 06 May 2008 22:34 GMT
Look in the help index for SUMIF

Signature

Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com

>I am new to Excel, I have a "for dummies" book but what I need, I have not
>a
[quoted text clipped - 15 lines]
> I appreciate any help, either how to do this or what it is called so I can
> figure out what to look under.
nrodADAA - 07 May 2008 17:45 GMT
Thank you!

> Look in the help index for SUMIF
>
[quoted text clipped - 17 lines]
> > I appreciate any help, either how to do this or what it is called so I can
> > figure out what to look under.
Bernard Liengme - 06 May 2008 22:37 GMT
Hi,
SUMIF works well: =SUMIF(D:D,"Telemarketing",A:A)
Could use =SUMIF(D:D,D1, A:A) with D1 holding the text Telemarketing
If you want to sum for Telemaketing in IL, then Excel 2007 has SUMIFS (ends
with S)

If you have time, do lean about Pivot Tables; they are so powerful
http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html
http://www.ozgrid.com/Excel/excel-pivot-tables.htm
http://www.techonthenet.com/excel/pivottbls/index.htm
http://www.dicks-blog.com/archives/2005/06/23/download-pivottable-parameters/

best wishes
Signature

Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

>I am new to Excel, I have a "for dummies" book but what I need, I have not
>a
[quoted text clipped - 15 lines]
> I appreciate any help, either how to do this or what it is called so I can
> figure out what to look under.
nrodADAA - 07 May 2008 17:45 GMT
Thank you so much for your help!  I will look into your suggestion and let
you know how I do!

> Hi,
> SUMIF works well: =SUMIF(D:D,"Telemarketing",A:A)
[quoted text clipped - 30 lines]
> > I appreciate any help, either how to do this or what it is called so I can
> > figure out what to look under.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.