Hi Lars-Åke hopefully response to Luke answered this, i.e.

Doesn't matter which result it returns as it'll always be the same e.g. in
your example both rows would just show 22 rather than 22 and 25 as you have
done. ZZ will never appear in two columns on the same row only once.
--
James.


"Lars-Åke Aspelin" wrote:

Well, what result do you expect if there is "ZZ" on more than one
row? If the corresponding value in columns D always be the same, e.g.
22, I guess you want that to be the result, but if there are different
values in columns D for the "ZZ" rows, then what should the result be?
The average, the sum, or what?

Lars-Åke

On Wed, 22 Jul 2009 05:45:01 -0700, James
wrote:

Thanks Lars-Åke

That's great it works! Another question though, what happens if "ZZ" appears
more than once i.e. more than one row has a "ZZ", it'll add them together
e.g. 2 "ZZs" would give a result of 44. How would you get around that?!