You used specific cell addresses, I wanted a formula which uses ROW() and
COLUMN().

On 11/1/04 10:41 PM, in article ,
"MikeY" wrote:

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