Search criterias?
 

Hi

I need to perform a sort of look-up into a grid of information. I need to find how many times two adjoining cells met a criteria. For example, the grid has random numbers in a 10x10 grid, I need to now how many times "5" AND "9" (for example) appear adjacent to each other in a row. If they are not next to each other the result should come back as zero or false.

I have tried the countif and Hlookup function, but does not account for them being adjacent.

Please help....THANKS

Search criterias?
 

Try this:

Assume the grid is in the range A1:J10

=SUMPRODUCT(--(A1:I10=5),--(B1:J10=9))

Biff

"shnim1" wrote in message
...

Hi

I need to perform a sort of look-up into a grid of information. I need
to find how many times two adjoining cells met a criteria. For example,
the grid has random numbers in a 10x10 grid, I need to now how many
times "5" AND "9" (for example) appear adjacent to each other in a row.
If they are not next to each other the result should come back as zero
or false.

I have tried the countif and Hlookup function, but does not account for
them being adjacent.

Please help....THANKS




--
shnim1