Posted to microsoft.public.excel.worksheet.functions

Uggywuggy

external usenet poster

Posts: 3

COUNTIF - Multiple Criteria

I'm trying to count the number of rows where a cell DOESN't equal a number of
values. I know this isn't the syntax but am looking for something as follows;

i.e. COUNTIF(A1:A100,"<NEW", "<CLOSED", "<MONITOR")

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Use multiple criteria with COUNTIF: between dates and not blank	l.shields	Excel Worksheet Functions	13	July 27th 09 06:53 PM
Counting cells using multiple criteria	andrew.curley	Excel Worksheet Functions	4	June 12th 06 04:41 PM
Multiple Criteria using countif	calmo	Excel Worksheet Functions	6	October 25th 05 08:33 PM
multiple criteria in one field 4a,4b etc of countif?	Anne-Marie	Excel Discussion (Misc queries)	1	October 20th 05 02:23 PM
Multiple CountIf Criteria	JerryS	Excel Worksheet Functions	1	October 14th 05 07:14 PM

All times are GMT +1. The time now is 10:15 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us