Great! Thankyou Max for your prompt reply.

Kaye Seeton


On Sun, 28 Nov 2004 22:50:45 -0800, "Max"
wrote:

Try this modification to your 1st formula:
(added another IF condition to ignore "Trace")

=SUM(IF(LEFT(D5:D35)="*",MID(D5:D35,2,LEN(D5:D35) )+0,IF
(TRIM(D5:D35)="Trace","",(D5:D35)+0)))

Above formula is array-entered with
CTRL+SHIFT+ENTER, instead of just ENTER