compare areas

[Øyvind Granberg]

Hi..

I need to compare two area containing 3*12 cells, and get number of cells
matching in content and placement.


Excel 2007 have the compare funksion, but it comes up with an value-error.

Excel 2007 norwegian edition.



--


Zadig Galbaras
(nick)
www.tresfjording.com

 

[T. Valko]

Try this:

=SUMPRODUCT(--(A1:C12=G1:I12))

 

[Øyvind Granberg]

No that just sums it all up...

I want to count the not-empty cells in a matrice...
The cells contains letters, not numbers...

It's like this...
In area A_one, 3*12 cells, there are cells containing the letter Z.
In area A_two, also 3*12 cells, there are cells containing the letter Z,

How many of those correspond?

As if you lay two patterns on top of each other to see where they are
similar.

--


Zadig Galbaras
(nick)
www.tresfjording.com

 

[T. Valko]

No that just sums it all up...

No, it counts how many cells are equal comparing the first array to the
second array.

In area A_one, 3*12 cells, there are cells containing the letter Z.
In area A_two, also 3*12 cells, there are cells containing the letter Z,

Maybe this:

=SUMPRODUCT((A1:C12="Z")*(G1:I12="Z"))