| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
I Need to Count Number of Entries Based on Two Criteria
I need to count the number of entries in column B only if column J does not
equal "1" AND column B is 3. Not looking for a "sum" or to "multiply", I simply need a count of the number of entries in column B that match these two criteria. I have tried combining functions through IF and COUNTIF, but have not been successful. Any ideas? Thanks :) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "COUNTU" function in Excel to count unique entries in a range | Excel Worksheet Functions | |||
| Creating a certain number of entries based on a number in a cell | Excel Worksheet Functions | |||
| Count Number of Characters in a cell? | Excel Discussion (Misc queries) | |||
| Count based on another column | Excel Discussion (Misc queries) | |||
| Count rows based on multiple criteria | Excel Worksheet Functions | |||
Threaded Mode
