Count Number of Times Something appears

G

Guest

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
 
B

Bob Phillips

=COUNTIF(Sheet2!A:A,B1)

etc.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
G

Guest

Hey Mark,
If you want to give Bob the credit, you should mark this question "answered."
 
B

Bob Phillips

Where I am Anne, the public newsgroups, there is no such concept :)).

--

HTH

RP
(remove nothere from the email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count # items in ColA if blank in ColB 11
Countif depending on the conditions across multiple columns 1
Comparing two columns of numbers 2
Counting based on criteria from two cells??? 3
COUNTIF or COUNT.... IF 2
BETTER SPACING - If Then Date Range 7
IF function 4
Automating a computation process 3

Top