| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
