| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple criteria
Hi
This question has probably been asked (and answered) a million times... I have the following sheet A B Peas 1 Aug Peas 2 Aug Beans 1 Aug Peas 2 Aug Beans 2 Aug I want a formula that can tell me how many times the word "Peas" appears for a specific date (eg 1 Aug). My worksheet has hundreds of rows of information and I do not want sort. I want to type in the word "Peas" and it should give a total. Thanks in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count multiple cells against multiple criteria in an Excel spreads | Excel Worksheet Functions | |||
| match multiple criteria ina range from multiple criteria multiplet | Excel Worksheet Functions | |||
| Index & Match functions - multiple criteria and multiple results | Excel Worksheet Functions | |||
| Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
| Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
![Greggo G[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
