count value

[wlinksanju]

need to count value .please help !!!!

[Glenn Kennedy]

Try this:

=COUNTIF('raw data'!A:A,summary!A5)

[wlinksanju]

Try this:

=COUNTIF('raw data'!A:A,summary!A5)

Dear Glenn thanks for quick reply ..but i want to count unique value of column B respectively to same value of column A

[Glenn Kennedy]

1. You did not ask for unique values.

2. There were no duplicates for either name.

3. You provided no expected results.

How am I supposed to guess what you want?

=SUM(INDEX(('raw data'!$A$3:$A$15=summary!A5)*('raw data'!$A$3:$A$15<>"")/COUNTIFS('raw data'!$B$3:$B$15,'raw data'!$B$3:$B$15&"",'raw data'!$A$3:$A$15,'raw data'!$A$3:$A$15&""),0))

[wlinksanju]

1. You did not ask for unique values.

2. There were no duplicates for either name.

3. You provided no expected results.

How am I supposed to guess what you want?

=SUM(INDEX(('raw data'!$A$3:$A$15=summary!A5)*('raw data'!$A$3:$A$15<>"")/COUNTIFS('raw data'!$B$3:$B$15,'raw data'!$B$3:$B$15&"",'raw data'!$A$3:$A$15,'raw data'!$A$3:$A$15&""),0))

I apologize for not being clear about result..

[wlinksanju]

I apologize for not being clear about result..

Thankyou very much

[Glenn Kennedy]

You're welcome.

---

If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.