Excel 2007

  • Thread starter Thread starter nrodADAA
  • Start date Start date
N

nrodADAA

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.
 
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
 
Thank you so much for your help! I will look into your suggestion and let
you know how I do!
 
Back
Top