View Single Post
  #2   Report Post  
MikeY
 
Posts: n/a
Default

B2: =SUMPRODUCT(C$1:G$1*(C2:G2="X"))

--
Mike

"The Shaffer s" wrote in message ...