Excel 2007
 

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.

Excel 2007
 

Look in the help index for SUMIF

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"nrodADAA" wrote in message
...
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.

Excel 2007
 

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/2...le-parameters/

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

"nrodADAA" wrote in message
...
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.

Excel 2007
 

Thank you so much for your help! I will look into your suggestion and let
you know how I do!

"Bernard Liengme" wrote:

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/2...le-parameters/

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

"nrodADAA" wrote in message
...
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.

Excel 2007
 

Thank you!

"Don Guillett" wrote:

Look in the help index for SUMIF

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"nrodADAA" wrote in message
...
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.