Re: urgent ......problems on group

Tech-Archive recommends: Fix windows errors by optimizing your registry

Ditto what Bob said, but just as an aside, without seeing anything else, i
would suggest you change your data structure such that all your data is
together in the same columns, eg:-

sales quantity

1 john 2
2 mary 4
3 nick 5
4 tom 7
5 linda 6 ...

This will give you far more flexibilty and allow you to use a host of other
functions that you have pretty much denied yourself by using your existing
structure, eg:-

Pivot Tables
Data / Subtotals

You will also find it much easier to structure formulas such as

SUMIF
COUNTIF
SUMPRODUCT etc

all of which can be used to obtain summary data from a table such as I have
suggested.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------­------------------------------­----------------



"pamela" <hfw@xxxxxxxxxxxxx> wrote in message
news:%23OPEJ84rFHA.3852@xxxxxxxxxxxxxxxxxxxxxxx
> Hi,
>
> I have a question here .
> My data structure is as follows:
>
> sales quantity sales quantity sales quantity
>
> row1 john 2 mary 4 nick 5
> row2 tom 7 linda 6 ...
>
>
> what I'm trying to do is to get total quantity group by
> sales .
>
> Could anybody please help me.
>
> any messages from you will be appreciated.
>
> best regards
>
>


.

Relevant Pages