Thanks Ola;
However for our requirements subtotals seem to work better. It appears to be
a bug in EXCEL and I have contacted MS support about this.
"Ola" wrote in message
...
Hi,

Hard to tell what's wrong but I would use a Pivottable for the 3
subtotals.

Ola