urgent ......problems on group

P

pamela

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
 
B

Bob Phillips

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)
 
K

Ken Wright

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 :)
------------------------------­------------------------------­----------------
 
P

pamela

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 ?
 
B

Bob Phillips

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)
 
K

Ken Wright

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...................
 
Top