countif with and
 

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 ***

countif with and
 

=sumproduct(--(A1:A100="Hello"),--(B1:B100="World"))

"Hello" and "World" could be replace by cell references that hold the term
you are counting.

=sumproduct(--($A$1:$A$100=M1),--($B$1:$B$100=N1))

N1: World
M1: Hello


--
Regards,
Tom Ogilvy



"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 ***

countif with and
 

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 ***