Posted to microsoft.public.excel.worksheet.functions

Bob

external usenet poster

Posts: 972

count many with COUNTIF?

Is there a way of doing this:
=COUNTIF(A1:A200;C2:C15)
without having to
=COUNTIF(A1:A200;C2)+COUNTIF(A1:A200;C3)+ ... ?

with best regards

P.S.
For those using a non-english Excel -- such as I (me?) -- translations of
functions in 9 languages: cherbe.free.fr/traduc_fonctions_xl97.html

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 for the number of a specific count?	[email protected]	Excel Worksheet Functions	2	June 27th 06 06:51 PM
Count consecutive dates only	[email protected]	Excel Discussion (Misc queries)	0	May 4th 06 03:58 PM
Using Countif to count occurences of time?	Liketoknow	Excel Worksheet Functions	5	February 6th 06 08:21 AM
Formula format for Count or Countif funtion with two criterias	Debi	Excel Worksheet Functions	2	September 26th 05 08:23 PM
want to count in two columns; countif (colA=x AND colB=y)?	Heather Murch	Excel Worksheet Functions	1	February 17th 05 03:47 PM

All times are GMT +1. The time now is 08:49 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us