"Tommy" wrote:
name score score total
player DQ 72 72
Another play to try, adapted from a post by Peo y'day,
Place in D2:
=IF(COUNTIF(B2:C2,"DQ")=2,"DQ",SUMPRODUCT(--(0&SUBSTITUTE(B2:C2,"DQ",""))))
Copy down
Adapt the ranges & the COUNTIF(...)= #
to suit the number of cols for the scores
(the formula above is for the sample data posted
which shows 2 score cols in cols B & C)
#: If there's 18 score cols, use COUNTIF(...)=18
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---