Search criterias?

S

shnim1

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
 
T

T. Valko

Try this:

Assume the grid is in the range A1:J10

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

Biff
 
Top