Hi all

I am trying to create a UDF (user defined function) that will enable me

to sum the golf score for the nine holes BUT with a difference. The

cells for the the nine holes whilst expecting numeric, will also allow

entry of just the following letters; d for DQ (disqualified), n for NR

(no return) and r for Rtd (retired). The UDF therefore must check each

of the 9 hole score and if in any one, there is a letter (say d) then

the total column must read DQ otherwise to sum the score of 9 holes.

Any help would be appreciated.

PS using XP with XL2003.

Rgds

K

## Bookmarks