Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
2003 Excel
This is my data:
CB 101 CC 201 CA 105 CC 123 CB 122 CA 109 Question: How do I sort the information given to tell me how many CA's I have and so on?? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
2003 Excel
Look in the help index for COUNTIF
-- Don Guillett Microsoft MVP Excel SalesAid Software "CC Bulinski" <CC wrote in message ... This is my data: CB 101 CC 201 CA 105 CC 123 CB 122 CA 109 Question: How do I sort the information given to tell me how many CA's I have and so on?? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
2003 Excel
Hi,
Is this data in 1 or 2 columns? Assuming 2: Then put your cursor in the first column and click the Ascending Sort, then choose Data, Subtotal, set At each change in to the first column, set Use function to Count, under Add subtotal to check the first column, click OK Alternatively =COUNTIF(A1:A100,"CA") or =COUNTIF(A1:A100,D1) where D1 contains CA -- If this helps, please click the Yes button. Cheers, Shane Devenshire "CC Bulinski" wrote: This is my data: CB 101 CC 201 CA 105 CC 123 CB 122 CA 109 Question: How do I sort the information given to tell me how many CA's I have and so on?? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
2003 Excel
I read your question slightly differently: you want to sum all the numbers
in column B where the corresponding A value is CA. =SUMIF(A1:A100,"CA",B1:B100) best wishes -- Bernard Liengme MVP Excel http://people.stfx.ca/bliengme "CC Bulinski" <CC wrote in message ... This is my data: CB 101 CC 201 CA 105 CC 123 CB 122 CA 109 Question: How do I sort the information given to tell me how many CA's I have and so on?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 attachments open and show only empty cells when openedvia Outlook 2003? | Excel Discussion (Misc queries) | |||
Convert Excel 2003 spreadsheet into Outlook Contacts table 2003 | Excel Discussion (Misc queries) | |||
import Excel 2003 file into Outlook 2003 - NO NAMED RANGES?? | Excel Discussion (Misc queries) | |||
Copying Excel 2003 Selection into Outlook 2003 HTML E-Mail Message | Excel Discussion (Misc queries) | |||
Excel 2003 Database Driver Visual FoxPro 7 on Server 2003. | Excel Discussion (Misc queries) |