Count Rows with two criteria

E

Eli Waite

I have info in Column A and B that goes for about 20,000 rows. I want Excel
to tell me how many occurances there are in Column A of "THIS" if Column B is
equal to "THAT" Any help would be greatly appreciated.
Thank you.
 
E

Eli Waite

Got it. Thanks for your help. I just had to realize that I could not do a D:D
(select the entire column), I actually had to pick the cells for the criteria
to search.
 

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

Copy addition formula of non-consecutive horizontal cells 2
How to center adjust text above and image in a two column document. 1
Trying to create custom labels from an csv file + Need items numerically counted out 0
Trying to count based on multiple criteria & cell comparisons 4
Need Help with a VBA subroutine 0
Using countif with multiple criteria 0
Integrating information from Word to Excel (not mail merge) 1
Help with a basic condition 0

Top