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