Hi!

Here's something a little shorter and it's not an array:

=SUMPRODUCT(--(SUBSTITUTE(SUBSTITUTE
(D5:D35,"trace","0"),"*","")))

Biff

-----Original Message-----
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

.