Counta,vlookup,match???

[huntingbugg]

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

 

[Dav]

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

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

Regards

Da

 

[Jim May]

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" <[email protected]>
wrote in message
news:[email protected]...

 

[Jim May]

Make that Your data in A1:B9...

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" <[email protected]>
wrote in message