urgent ......problems on group
 

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

Don't quite get the question Pamela. That already looks to be by sales, as
no item is repeated.

Are you asking to re-format it some way, or get totals by some criteria?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"pamela" wrote in message
...
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

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" wrote in message
...
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

Thanks for your messages.
I know if I reformat the structure , it will do , but the problem is that
we have about 200 files in that format . That's lot's of work.

What I need is does anybody know any function or formula that can help me to
sort this problem out ?

"Ken Wright" ¦b¶l¥ó
¤¤¼¶¼g...
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" wrote in message
...
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

I think you can tell from our responses that we don't understand what the
problem is.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"pamela" wrote in message
...
Thanks for your messages.
I know if I reformat the structure , it will do , but the problem is that
we have about 200 files in that format . That's lot's of work.

What I need is does anybody know any function or formula that can help me
to
sort this problem out ?

"Ken Wright" ¦b¶l¥ó
¤¤¼¶¼g...
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" wrote in message
...
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

Give us an example of what you have and what you would like to see. I'm in
the same boat as Bob, in that i can see a bit of data but don't know what
you want out of it.

Regards
Ken...................