Quote Originally Posted by Richard Buttrey View Post
Wouldn't it be simpler to concatenate B3:G3 into say A3, copy it down. Do the same with L4:Q4 in say K4, then in R4 use

Formula: copy to clipboard 
=COUNTIF(A:A,K4)
You can do it without the helpers

=SUMPRODUCT(--($B$3:$B$317&$C$3:$C$317&$D$3:$D$317&$E$3:$E$317&$F$3:$F$317&$G$3:$G$317=$L$4&M4&N4&O4&P4&Q4))