| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
=COUNTIF How to if 2 or more arguments???
Peo & Bob, Thanks for your help previously.
The only thing not covered was if there are multiple arguments (say a combination of text & or numbers). I tried this: =COUNTIF(Listing!I2:I420,"EXE","000") and keep getting: "You've entered too many arguments for this function." |
|
#2
|
|||
|
|||
|
Try
=SUMPRODUCT(--(Listing!I2:I420={"EXE","000"})) -- Regards, Peo Sjoblom "Trixie" wrote in message ... Peo & Bob, Thanks for your help previously. The only thing not covered was if there are multiple arguments (say a combination of text & or numbers). I tried this: =COUNTIF(Listing!I2:I420,"EXE","000") and keep getting: "You've entered too many arguments for this function." |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF statement w/ more than 7 arguments needed | Excel Worksheet Functions | |||
| Are there too many arguments | Excel Worksheet Functions | |||
| Event hundler to control the Excel function arguments | Excel Worksheet Functions | |||
| How to specify almost full-column arguments like A3:A | Excel Discussion (Misc queries) | |||
Hybrid Mode
