Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pasting a chart from Excel 2007 to Word 2007 trouble | Charts and Charting in Excel | |||
Paste EXCEL 2007 sheet into WORD 2007 - objects move around | Excel Discussion (Misc queries) | |||
How can I add the OneNote 2007 icon to the ribbon in Excel 2007? | Excel Discussion (Misc queries) | |||
Chart Selection - Excel 2007 copy to Powerpoint 2007 | Charts and Charting in Excel | |||
how to email excel 2007 worksheet with outlook 2007 | Excel Worksheet Functions |