| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count Number of Times Something appears
On Sheet 1, I want to put a formula in ColA that tells the number of times
ColB occurs in Sheet 2, ColA. THANKS! Sheet 1 Sheet 2 ColA ColB ColA A401 A401 A402 A401 A403 A402 A404 A402 A405 A403 A404 A404 A405 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count Number of Times Something appears
Use the CountIF function.
- John |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count Number of Times Something appears
=COUNTIF(Sheet2!A:A,B1)
etc. -- HTH RP (remove nothere from the email address if mailing direct) "Mark B" wrote in message ... On Sheet 1, I want to put a formula in ColA that tells the number of times ColB occurs in Sheet 2, ColA. THANKS! Sheet 1 Sheet 2 ColA ColB ColA A401 A401 A402 A401 A403 A402 A404 A402 A405 A403 A404 A404 A405 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count Number of Times Something appears
=COUNTIF(Sheet2!A:A,B1)
Thanks Bob, that's great... |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count Number of Times Something appears
Hey Mark,
If you want to give Bob the credit, you should mark this question "answered." -- Anne Murray "Mark B" wrote: =COUNTIF(Sheet2!A:A,B1) Thanks Bob, that's great... |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count Number of Times Something appears
Where I am Anne, the public newsgroups, there is no such concept :-)).
-- HTH RP (remove nothere from the email address if mailing direct) "FinRazel" wrote in message ... Hey Mark, If you want to give Bob the credit, you should mark this question "answered." -- Anne Murray "Mark B" wrote: =COUNTIF(Sheet2!A:A,B1) Thanks Bob, that's great... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I count the # of times a value reoccurs and plot it over ti | Charts and Charting in Excel | |||
| I Need to Count Number of Entries Based on Two Criteria | Excel Worksheet Functions | |||
| Count number of times a specific number is displayed in a cell ran | Excel Worksheet Functions | |||
| Count number to reach a cumulative value | Excel Worksheet Functions | |||
| Whats the function to count the total times a word is displayed | Excel Discussion (Misc queries) | |||
Hybrid Mode
