Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I can't find anything in the help. I need to be to count more than one
criteria. Is this possible? As an example. A B 1 New York Baseball 2 New York Football 3 Cincinnati Baseball 4 Cleveland Baseball I want to be able to display this in another workbook B C Baseball Football 1 New York 1 1 2 Cincinnati 1 0 3 Cleveland 1 0 So as an example, what formula can I use in cell B1 to count both criteria, both New York and baseball. Thanks in advance Doug |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I use a countif function according to two other countif fu. | Excel Worksheet Functions | |||
edit this =COUNTIF(A1:F16,"*1-2*")+COUNTIF(A1:F16,"*2-1*") | Excel Discussion (Misc queries) | |||
COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
countif | Excel Worksheet Functions | |||
COUNTIF in one colum then COUNTIF in another...??? | Excel Worksheet Functions |