Hi,
I have the data set in Excel 2003, of which the following is a
representative:

UAB Title Code Applicants
Zig X 001300 31
Y 001340 22
Z 001350 11
Zag A 002720 23
B 002730 24


I want to add subtotals to count the applicants for each UAB, Zig and
Zag. The UAB column has blank cells, but X,Y and Z are all Zig, and
A,B are Zag. So, what I want is this:

UAB Title Code Applicants
Zig X 001300 31
Y 001340 22
Z 001350 11
Zig Total 64
Zag A 002720 23
B 002730 24
Zag Total 47
Grand Total 111

My machines runs Excel 2003 SP2. When I do Data..Subtotals...Ok
(accepting all the default options), this works fine. On a colleague's
machine, who is running Excel 2003 with NO service packs, it doesn't
work. I get the following results:
UAB Title Code Applicants
Zig X 001300 31
Zig Total 31 <-this should be two rows further down
Y 001340 22
Z 001350 11
Zag A 002720 23
Zag Total 23 <-this should be one row further down
B 002730 24
Grand Total 111


As far as I can tell, this is not the same as the nested subtotals
problem (http://support.microsoft.com/kb/831824). I would like to test
the registry fix suggested by MS anyway, but unfortunately I cannot
edit my registry due to access problems. There doesn't seem to be
anything about this problem on the MS site or in the newsgroups.

Can anyone shed any light on this, or suggest a workaround?
(NB - "Install the most up to date service pack" is an obvious
workaround. Unfortunately, I work in a place with atrociously poor IT
infrastructure and support, so, ridiculously, this is not an option)

Thanks
Andy