Dave R. wrote:
Hi - I had nothing to do with creating that page. But I agree it is nice.
I just tried, and Excel doesn't seem to accept cell references in place of
numbers. Maybe someone can chime in with a way to pull off the (working)
equivilant of:
=SUMPRODUCT(--(A1:A10={d1,d2,d3})) (which does not work) to count values in
A1:A10 that match the content of either D1, D2 or D3.
[..]
=SUMPRODUCT(--ISNUMBER(MATCH(A1:A10,D1:D3,0)))
|