| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
PLS HLP! Countifs Syntax Problem?
Hi,
Let's say I have the following in two columns, with a cell that contain the criteria I wish to count: red apple orange pear green applies peach cherries red grapes green grapes apple grapes I wish to use Countifs to count the number of apples, no matter the colour, in both ranges, and grapes, no matter the colour, in both ranges. I have tried and tried, but seem to always come up with 0. PLS HLP! -- Thanks! Dee |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Incorrect syntax near '#' problem when returning to MS Query fromExcel | Excel Discussion (Misc queries) | |||
| Delete syntax problem | Excel Worksheet Functions | |||
| SendKeys syntax problem | New Users to Excel | |||
| .XValues syntax problem | Charts and Charting in Excel | |||
| Syntax problem | Excel Worksheet Functions | |||
Threaded Mode
