View Single Post
  #8   Report Post  
Dillenger
 
Posts: n/a
Default

This is exactly what I need. Thank you all for your help :)

"Ola" wrote:

...and that should be...
=SUMPRODUCT(--( (A1:A3 & B1:B3 & C1:C3) = (A1 & B1 & C1) ) )

I added a few " " to make it easier to read.
Ola