Problem with 2 levels of subtotals

[May]

I have a weird situation here.

I'm trying to create 2 levels of subtotals from the
spreadsheet.

I have no problem creating 2 levels of subtotals using
Excel 2000. However, with Excel 2003 I keep on
getting 'mix up' answers on the second level subtotal.
The first level of subtotal works fine until I try to
create the second level of subtotals.

Can somebody please advice whether is there a way around
this problem in Excel 2003?

Thanks in advance

 

[Dave Peterson]

I'm not sure what mixed up answers are, but there are a couple of things that I
can think of that can go astray.

#1. The "numbers" in your table are really text.
You can test it with =count(b2:b11) (or whatever your range is)
It'll come back with the number of cells that are really numbers.

#2. You applied data|subtotals in the wrong order.
Remove them and try it in the opposite way.

And I don't use xl2003, but there's a List option (hi, AlfD!). Could you be
using that and could that cause the problem?

 

[May]

Hi Dave,

I tried out the same spreadsheet on Excel 2000 and Excel
2003. It works well only on Excel 2000. However, it
appears differently in Excel 2003. Same steps, same
spreadsheet but different answers on different version.

Please advice.

Thanks.

 

[Dave Peterson]

I don't use xl2003, so I don't think I can help.

Maybe someone else can jump in.