Have you tried including a term like:

(ISNUMBER(sum_range))

?

Hope this helps.

Pete

On Sep 4, 12:40*pm, Thanks wrote:
Hi
My Sum range occasionally has text included in it, *is there a a way to make
sum product ignore the test when evaluating?