Thread: Count question
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sung Sung is offline
external usenet poster
 
Posts: 9
Default 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