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.
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.