Lorenzo,

Don's formula is the way to go
=sumproduct(($b$2:$b$2000="name1")*($d$2:$d$2000=" A")*$m$2:$m$2000)

but instead of using "name1", have the names listed in column A (same line
as the formula and replace "name1" with A2001 (assuming the formula is on
line 2001. Than fill the formula down to match the list of names.

This makes it easier to set up the formulas without a lot of typing and also
allows quick changes to the list. Also prevents typos, especially if you
paste the name list from an advanced filter of the data. (I use this all
the time and it works a treat).

steve

"Lorenzo" wrote in message
om...
Don, again thank you very much for your help. As you said, formulas
are definetly the way to go, and I was thinking of keeping the thing
simple by having the sums made by formulas on the same sheet, hide the
column with the formulas and have a simply copy and paste function
between the two sheets (which, I forgot to mention, are on two
different workbooks). Not understanding too much what your formula did
(I'm a bit thick) I started fooling around with the insert function
comand menu to see what I would come up with, and I found that the
SUMIF formula is pretty close to what I need. As a matter of fact,
it's exactly what I need, except for two slight glitches. As it is, my
formula is

=SUMIF(B:B,"=name1,M:M)

where B is the column the names of the clients is, and M is the column
where the transaction value is.
Again, I'm stuck on the same two problems, meaning:
1. I have to manually add every single client's name and have a
separate row for each formula, but if this is the only way, so be it.
2. Most importantly, I don't seem to be able to have the formula work
on two criterias, meaning that as it is, it sums both sales and
purchases (not excatly what I had in mind). Therefor, I would need the
formula to check if the value in column D is either A or D.

Again, any suggestions?
Thanks a lot for all your help - I really hope your not losing too
much time on this imbecille that can't even figure out a double
criteria problem on his own...
Lorenzo