View Single Post
  #6   Report Post  
Ola
 
Posts: n/a
Default

Is this what you want?

=SUMPRODUCT(--((G17:G20&H17:H20&I17:I20)=(G17&H17&I17)))
--2

Ola Sandstrom


Note:
The '&' concatenates the A, B and C column
-- is a way to convert all True to 1 and all False to 0
Sumproduct is "a formula to work with Arrays (many rows/col's at one time)"