| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
find text and count word 2 cells beside
have a word in cell B10 (BOX195) and want to find all the BOX195 in column
B:B and count how may have the word OUT in the column D. Note it is a big database with lots of different BOX numbers. ??? =COUNTIF(B:B=B10,and(D:D="OUT")) ??? ??? =COUNTIF(B:B,B10,D:D="OUT") ??? Column A Column B Column C Column D 1 BOX085 bbb OUT 2 BOX195 BBB OUT 3 BOX102 bbb OUT 4 BOX195 BBB IN 5 BOX102 bbb IN 6 BOX195 BBB OUT 7 BOX085 bbb IN 8 BOX195 BBB OUT 9 BOX085 bbb OUT 10 BOX195 BBB IN |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need a formula to 'find' word in cells of column from a long list | Excel Worksheet Functions | |||
| Find, count and extract duplicate cells | Excel Worksheet Functions | |||
| Count Occurance of Text/Word in a Range | Excel Discussion (Misc queries) | |||
| Count single Text in cells with multiple text entries | Excel Discussion (Misc queries) | |||
| In Excel, how do I find one word in a set of text in a cell? | Excel Discussion (Misc queries) | |||
Threaded Mode
