Check out this link on sumproduct...

http://www.xldynamic.com/source/xld.SUMPRODUCT.html
--
HTH...

Jim Thomlinson


"Kamal Teja" wrote:

Hi Jeff,

I need to workout with countif And together here is my requirement
A B
hello world
hello world
hello world
hello world
hello globe
hello globe
hello globe
hello country
hello country
hello country
hello country
hello country

I want to display the count of hello+world or hello+globe or
hello+country

I tried with following possibilities
1.countif(and())
2.count(if(and))
3.count(if())
4.count(and())
5.sum(if(and())
6.sumproduct
and may other possibilities
could you get me the exact formula which could result my required output

I've mailed you from my mail id which bounced back
...



*** Sent via Developersdex http://www.developersdex.com ***