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

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

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

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

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

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