| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count question
What is the formula to count from a column based on multiple criteria.
For example, City Los Angeles Phoenix Los Angeles New York Chicago New York so i would like a formula to return the total count of new york and los angeles. In this example it would be 4. Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count question
=COUNTIF(A1:A6,"New York")+COUNTIF(A1:A6,"Los Angeles")
-- Gary''s Student "Sung" wrote: What is the formula to count from a column based on multiple criteria. For example, City Los Angeles Phoenix Los Angeles New York Chicago New York so i would like a formula to return the total count of new york and los angeles. In this example it would be 4. Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count question
=SUM(IF(A1:A5="Los Angeles",1,0))+SUM(IF(A1:A5="New York",1,0))
Press control-shift-enter to enter it as a formulaic array -- http://HelpExcel.com "Sung" wrote: What is the formula to count from a column based on multiple criteria. For example, City Los Angeles Phoenix Los Angeles New York Chicago New York so i would like a formula to return the total count of new york and los angeles. In this example it would be 4. Thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count question
THANKS!!!
"Gary''s Student" wrote: =COUNTIF(A1:A6,"New York")+COUNTIF(A1:A6,"Los Angeles") -- Gary''s Student "Sung" wrote: What is the formula to count from a column based on multiple criteria. For example, City Los Angeles Phoenix Los Angeles New York Chicago New York so i would like a formula to return the total count of new york and los angeles. In this example it would be 4. Thanks |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count question
THANKS!!!
"galimi" wrote: =SUM(IF(A1:A5="Los Angeles",1,0))+SUM(IF(A1:A5="New York",1,0)) Press control-shift-enter to enter it as a formulaic array -- http://HelpExcel.com "Sung" wrote: What is the formula to count from a column based on multiple criteria. For example, City Los Angeles Phoenix Los Angeles New York Chicago New York so i would like a formula to return the total count of new york and los angeles. In this example it would be 4. Thanks |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count question
Try this:
=SUM(COUNTIF(A1:A7,{"New York","Los Angeles"})) -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Sung" wrote in message ... What is the formula to count from a column based on multiple criteria. For example, City Los Angeles Phoenix Los Angeles New York Chicago New York so i would like a formula to return the total count of new york and los angeles. In this example it would be 4. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count and Count if funtions | Excel Worksheet Functions | |||
| Count Question | Excel Discussion (Misc queries) | |||
| complex count question | Excel Worksheet Functions | |||
| Pivot Tables - "simple" question | Excel Discussion (Misc queries) | |||
| Conversion | Excel Worksheet Functions | |||
Linear Mode
