| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
What's the correct formula?
Hi all,
I'm looking for the correct formula for this expression. =COUNTIF((Your_Range,"hat and coat") or COUNTIF(Your_Range,"hat")) and (range,"New York") The first two criteria are possible selections and the third is a must in order to count the record as 1 My question is what would be the logical expression(formula) to show this. -- -- Cheers |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| problem with formula | Excel Discussion (Misc queries) | |||
| Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
| Offset & Match Formula Shows Duplicates | Excel Worksheet Functions | |||
| Excel 2003 - Formula result shows as 0:00 | Excel Worksheet Functions | |||
| Formula window displays correct answer while cell displays incorre | Excel Worksheet Functions | |||
Threaded Mode
