actually.. i have a change to my previous post. the dealer subtotals are
correct. however Q4 is appearing under the dealer total instead of above the
dealer subtotal with Q1, Q2 and Q3. Again, the dealer subtotal adds up to
all four Qs but the fourth quarter is appearing beneath the dlr subtotal in
the middle of the worksheet. the beginning of the spreadsheet the data was
appearing fine. it looks like it bombed out with my first dealer that only
had one line of data in Q1. at that point i got a dealer total, but the q1
total appeared beneath it.

I'm perplexed. Advice welcomed.

Chris
--
Thanks!


"learningaccess" wrote:

Hi... I have a worksheet of data that I want to sort by Dealer number and
then by quarter (Q1, Q2, Q3, Q4). I am trying to subtotal by dealer number
and have the sum of each quarter contained within. I subtotaled by dealer.
Then I subtotaled again by quarter ... without replacing previous subtotal.

It seemed to work. But in the middle of the data it blew up and started
counting Q4 of the one dealer in the subtotal of the next dealer and on and
on.

So the subtotals by quater were correct, but the subtotals by dealer were
inaccurate. EX dealer 1=Q1+Q2+Q3.... dealer 2 =Q4 dlr 1 +Q1+Q2+Q3.

Please help!!! I can't figure out where it's bombing out.
Thanks,
Chris
--
Thanks!