Hi!

Try this:

=SUMPRODUCT(--(A1:A5=2),--(B1:B5=1),--(C1:C5=2))

Biff

"hadmybreaktoday"
<hadmybreaktoday.1u0zeq_1124478361.2743@excelfor um-nospam.com wrote in
message news:hadmybreaktoday.1u0zeq_1124478361.2743@excelf orum-nospam.com...

I need help in finding how many rows contain a common series. For
example, if cells A1-A5, B1-B5, and C1-C5 all contain a single-digit
value of either 1, 2, or 3, I need to know what function to use that
tells me how many rows contain the following series, 2, 1, 2, in that
order. I have created a rough visual below. As you can see, 2 rows
contain the series 2, 1, 2. The formula I am looking for would return
to me the value of "2" since rows 4 and 5 both contain that specific
series. I am working with a data pool that contains 130 different
reference points (the column titles) and each refrence point has 140
data entries. I need to compare several colums to one another and do
not want to have to pick out a specific series manually. Any help will
be greatly appreciated!

A B C
2 2 1
2 3 3
2 1 2
2 1 2
3 2 3


--
hadmybreaktoday
------------------------------------------------------------------------
hadmybreaktoday's Profile:
http://www.excelforum.com/member.php...o&userid=26463
View this thread: http://www.excelforum.com/showthread...hreadid=397327