View Single Post
  #15   Report Post  
Harlan Grove
 
Posts: n/a
Default

Harlan Grove wrote...
....
=1+SUMPRODUCT(--((A2:A3&B2:B3&C3:C3)=(A1&B1&C1)))


Typo. that should have been

=1+SUMPRODUCT(--((A2:A3&B2:B3&C2:C3)=(A1&B1&C1)))