Counta,vlookup,match???
 

I am trying to count the number of items times two words are displayed
next to each other in two different columns
For example below:

Cat Leg
Dog Arm
Horse Leg
Dog Arm
Cat Leg
Horse Arm


Is there a formula that I can use to count the number of times cat and
leg apear next to each other


--
huntingbugg
------------------------------------------------------------------------
huntingbugg's Profile: http://www.excelforum.com/member.php...o&userid=32019
View this thread: http://www.excelforum.com/showthread...hreadid=517719

Counta,vlookup,match???
 

You need to use sumproduct, if the data is in a2:b7 the following should
work for your example

=SUMPRODUCT((A2:A7="cat")*(B2:B7="leg"))

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=517719

Counta,vlookup,match???
 

With your data in A1:A9 I entered in Cells C1
=A1&B1

and in D1 =COUNTIF($C$1:$C$9,C1)

and copied down

Maybe?

"huntingbugg"
wrote in message
...

I am trying to count the number of items times two words are displayed
next to each other in two different columns
For example below:

Cat Leg
Dog Arm
Horse Leg
Dog Arm
Cat Leg
Horse Arm


Is there a formula that I can use to count the number of times cat and
leg apear next to each other


--
huntingbugg
------------------------------------------------------------------------
huntingbugg's Profile:
http://www.excelforum.com/member.php...o&userid=32019
View this thread: http://www.excelforum.com/showthread...hreadid=517719

Counta,vlookup,match???
 

Make that Your data in A1:B9...

"Jim May" wrote in message
news:R2fNf.192789$oG.154674@dukeread02...
With your data in A1:A9 I entered in Cells C1
=A1&B1

and in D1 =COUNTIF($C$1:$C$9,C1)

and copied down

Maybe?

"huntingbugg"
wrote in message
...

I am trying to count the number of items times two words are displayed
next to each other in two different columns
For example below:

Cat Leg
Dog Arm
Horse Leg
Dog Arm
Cat Leg
Horse Arm


Is there a formula that I can use to count the number of times cat and
leg apear next to each other


--
huntingbugg
------------------------------------------------------------------------
huntingbugg's Profile:
http://www.excelforum.com/member.php...o&userid=32019
View this thread:
http://www.excelforum.com/showthread...hreadid=517719