| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Count Rows with two criteria
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. |
|
#3
|
|||
|
|||
|
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. "Dave R." wrote: http://www.xldynamic.com/source/xld.SUMPRODUCT.html#new "Eli Waite" <Eli wrote in message ... 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. |
|
#4
|
|||
|
|||
|
It does mention that on that page.
-- HTH Bob Phillips "Eli Waite" <Eli wrote in message ... 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. "Dave R." wrote: http://www.xldynamic.com/source/xld.SUMPRODUCT.html#new "Eli Waite" <Eli wrote in message ... 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions | |||
| Count Unique Names in list w/ Additional Criteria? | Excel Worksheet Functions | |||
| Counting rows based on criteria in multiple cells | Excel Discussion (Misc queries) | |||
| Counting "rows", i.e. simultaneous criteria for multiple cells | Excel Worksheet Functions | |||
| Count rows based on multiple criteria | Excel Worksheet Functions | |||
Linear Mode
