Count

[mangesh]

Hi,

From Cell A1 to Cell A50 I have names of My friends and from cell C1 to Cell C50 I have their location. Now i would like to count numbers of friend from different location. For example, I have Michael who resides in New York and One more person with same name but in different location say New Jersey, Now i would like to count michael from both the location.

[carsto]

read this

http://www.cpearson.com/excel/array.htm

[oldchippy]

Hi,

From Cell A1 to Cell A50 I have names of My friends and from cell C1 to Cell C50 I have their location. Now i would like to count numbers of friend from different location. For example, I have Michael who resides in New York and One more person with same name but in different location say New Jersey, Now i would like to count michael from both the location.

Hi mangesh,

Try this,

=COUNTIF(A1:A50,"Michael")

oldchippy