View Single Post
  #9   Report Post  
Aladin Akyurek
 
Posts: n/a
Default

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)))