Posted to microsoft.public.excel.programming

Robert[_22_] Robert[_22_] is offline

external usenet poster

Posts: 1

EXCEL multiple criteria in countif function

is it possible to have two criteria for a countif
statement like (COUNTIF(A1:A100,=2))or(COUNTIF
(A1:A100,"*2*"))

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
COUNTIF function for multiple criteria	yorkshirelass	Excel Worksheet Functions	8	June 18th 09 01:45 PM
Countif Function w/ multiple Criteria	LaTanya	Excel Worksheet Functions	2	November 13th 08 09:42 PM
Using the CountIf function with multiple criteria?	Jonathan	Excel Worksheet Functions	11	January 9th 08 06:34 PM
COUNTIF or SUM function (Multiple criteria) HELP!!	Australia	Excel Worksheet Functions	3	September 19th 05 07:39 AM
countif function with multiple criteria	Geoff	Excel Discussion (Misc queries)	1	August 11th 05 11:50 PM

All times are GMT +1. The time now is 01:27 PM.

About Us

"It's about Microsoft Excel"