| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
count many with COUNTIF?
Try this:
=SUMPRODUCT(COUNTIF(A1:A200,C2:C15)) Biff "Bob" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
count many with COUNTIF?
Thank you, but no, that didn't work; I get the wrong result "0". Although I'm
not quite sure what Excel is counting... What I want to count is strings (if that is complicating everything), i.e 'how many' of this, that and the other in A1:A200; "this, that and the other" is specifyed in C2:C15. This ought to be possible, one might think... Bob |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
count many with COUNTIF?
I retract my answer!!! It does work, human error...
Thank you very much Biff!! Bob "Bob" skrev: Thank you, but no, that didn't work; I get the wrong result "0". Although I'm not quite sure what Excel is counting... What I want to count is strings (if that is complicating everything), i.e 'how many' of this, that and the other in A1:A200; "this, that and the other" is specifyed in C2:C15. This ought to be possible, one might think... Bob |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
count many with COUNTIF?
I was concerned after reading your first reply but I feel better now!
You're welcome. Thanks for the feedback! Biff "Bob" wrote in message ... I retract my answer!!! It does work, human error... Thank you very much Biff!! Bob "Bob" skrev: Thank you, but no, that didn't work; I get the wrong result "0". Although I'm not quite sure what Excel is counting... What I want to count is strings (if that is complicating everything), i.e 'how many' of this, that and the other in A1:A200; "this, that and the other" is specifyed in C2:C15. This ought to be possible, one might think... Bob |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Countif for the number of a specific count? | Excel Worksheet Functions | |||
| Count consecutive dates only | Excel Discussion (Misc queries) | |||
| Using Countif to count occurences of time? | Excel Worksheet Functions | |||
| Formula format for Count or Countif funtion with two criterias | Excel Worksheet Functions | |||
| want to count in two columns; countif (colA=x AND colB=y)? | Excel Worksheet Functions | |||
Hybrid Mode
