| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
And/or Functions /Countif Function
I need to And /Or with the countif function. How do I do this?
-- Brian |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
And/or Functions /Countif Function
An accurate answer was given in your first posting of this question. If you
write the formula correctly, this is the way it is done. countif does not work with the AND/OR functions for criteria. suggestion was tested and worked fine. -- Regards, Tom Ogilvy "brianwakin" wrote in message ... I need to And /Or with the countif function. How do I do this? -- Brian |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
And/or Functions /Countif Function
Looking back at a previous post (among several), it looks like your data is
not in a single column as you previously stated in yet another post. You have received examples of sumproduct to see how to deal with that. Again, countif does not work with multiple criteria beyond what I showed you. -- Regards, Tom Ogilvy "brianwakin" wrote in message ... I need to And /Or with the countif function. How do I do this? -- Brian |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CountIf Functions | Excel Worksheet Functions | |||
| Using COUNTIF and AND functions together | Excel Worksheet Functions | |||
| countif functions | Excel Worksheet Functions | |||
| CountIf functions | Excel Discussion (Misc queries) | |||
| COUNTIF functions | Excel Worksheet Functions | |||
Hybrid Mode
