count unique and same with reference to its value

[sanjyou]

I need to find count for unique and for same multiple value

( ram task Assigned To same type of Names e.g hari=2 times and sanju= 3 times ) result =5

( ram task Assigned to different type of Names e.g anu=1 times,raju= 1 times,shyam = 1 times )=3

please help !!!!!!!!!

 

[sanjyou]

Did you change the formula to include the sheet name in the range references?

No shall i change it?

 

[Fluff]

Yes, if the formula is not on the same sheet as the data you need to include the sheet name.

 

[sanjyou]

Its working ....Thankyou very much...

 

[Fluff]

Glad we could help & thanks for the feedback.