| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count Vaules in a range that appear in another range
I have three ranges e.g.
Range 1 Range 2 Range 3 Bread Apples Bread Apples Oranges Buns Oranges Pears Buns Bread Pears Apples I'm trying to construct a formula that counts the number of times, say, and entry in Range 3 appears in Range 1 - In this instance the answer would be 3. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I enter formula sum(range+range)*0.15 sumif(range=3) | Excel Discussion (Misc queries) | |||
| Multiple Criteria, Count If, Sum Product to get count across range | Excel Worksheet Functions | |||
| Sum first five vaules of changing range | Excel Discussion (Misc queries) | |||
| How to count dates within a certain range in a column with mutiple date range entries | Excel Worksheet Functions | |||
| Count cells in one range based on parameters in another range | Excel Worksheet Functions | |||
Threaded Mode
