subtotal issues with NULL cells

[David French]

I have a worksheet of raw data. One of the columns has 3 unique
values...either 1, 2 or no data at all (NULL).
Without inserting some value in this cell, is there some way of doing a
Subtotal of all 3 of these values. At the moment the grouping that is done
on that value is lumped into the "1's". Naturally they aren't counted but
there is no separation either.

I know Pivot Tables would work but i'm looking for something easy and
straightforward.

Dave French

 

[Dave Peterson]

I didn't get that result when I tested (xl2003).

Are you sure you used the correct range? I like to select my range--and not let
excel guess.

 

[David French]

So you create the group manually instead of the 'automatic' subtotaling?
I haven't done much manual group and outline work. I guess I have relied on
the built in commands too much.

So with that in mind, once the proper grouping has been applied, how is the
subtotal arrived at?

Dave French

 

[Dave Peterson]

Nope.

I just select my range first (like A1:X999). Then I use data|subtotals.

In fact, I very rarely use data|group on rows. I can live with the extra
subtotals (even if I don't want them)--just to save time.