Home |
Search |
Today's Posts |
#1
|
|||
|
|||
countif
maryj Wrote: I have a client that needs to do a countif. The problem is is that the range is not consecutive cells. For example the range may be C3, E3, G3 but not including D3 or F3. How can this be done? Thanks Biff, That works great for 1 criteria. I didn't mention this the first time, my fault. I need a count for all that are either greater than 1 or less than 1. -- maryj |
#2
|
|||
|
|||
Use <1 or check out Chip Pearson's CountIf with Multiple Criteria at ...
http://www.cpearson.com/excel/array.htm HTH, Gary Brown "maryj" wrote: maryj Wrote: I have a client that needs to do a countif. The problem is is that the range is not consecutive cells. For example the range may be C3, E3, G3 but not including D3 or F3. How can this be done? Thanks Biff, That works great for 1 criteria. I didn't mention this the first time, my fault. I need a count for all that are either greater than 1 or less than 1. -- maryj |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combining IF and COUNTIF based on two columns | Excel Discussion (Misc queries) | |||
COUNTIF in one colum then COUNTIF in another...??? | Excel Worksheet Functions | |||
Countif | Excel Worksheet Functions | |||
Countif - Countif | Excel Worksheet Functions | |||
countif, again | Excel Worksheet Functions |