Hi,

You don't need a macro to do this; you can make use of
formula arrays.

Set up a fifth column which is just quantity * price

On your summary page type in formulaa similar to (not
forgetting to add worksheet references):

SUM((A2:A6="name1")*(B2:B6="A")*(E2:E6))
SUM((A2:A6="name1")*(B2:B6="D")*(E2:E6))
SUM((A2:A6="name2")*(B2:B6="A")*(E2:E6))
SUM((A2:A6="name2")*(B2:B6="D")*(E2:E6))

You'll need to press Shift+Ctrl+Enter to enter the formula
otherwise you may get incorrect results.

To solve your problem with name changes you should
reference the names from the summary sheet rather than
hard coding them into the formulae.

You can count the number of operations using:

CountIf(A2:A6,"name1")

Hope this is useful

:-)

Rob



-----Original Message-----
Hello, I hope somebody can help.
I have a sheet ordered in the following way

client sign quantity price
name1 A 3 12
name1 D 4 57
name2 A 2 12
name2 A 4 100
name2 D 3 10

where A means the client has bought something and D means
he is
selling.
I would need a macro that will give on a new sheet the
output of the
total operations of the client and how many operations he
has done.
Example

cilent total bought total sold n. of operations
name1 36 (i.e. 3x12) 228 2
name2 424 30 3


Unfortunately, the names change every now and then, so
inserting the
name in the macro would eventually prove pointless.
I have some experience with VB, but am totally at loss
with this
problem (obviously I'm not as good as I wish I were).
Thank you very
much for any help you might be able to give me.
Lorenzo
.

Don, Rob, thank you both for your help and your time, I really
appreciate it. Still, I'm not to sure what to do with the formulae (I
know this sounds weird, but I feel a lot more at ease with macros).
Rob, thanks for the suggestion on the new column with the total value
Referencing the names would take way too long (there are some 1300
names). Besides, new names are added every now and then, meaning I
would have to explain the process to every other person using the file
(and the names in the original DB are retreived from an AS400). What I
had in mind was a macro that worked sort of like this:

If name in next cell is the same and value in column B is A, then
sum value in col. F
until next cell = blank

And make a second similare macro for the D operations, adding for both
something that will count how many cells have been summed.
I hope this makes sense and that you may be able to help me - VB
knowledge just seems to be something I will never fully acheive.
Again, thank so much for all your help.
Lorenzo