Thread
:
summing values according to name in defferent column
View Single Post
#
1
Posted to microsoft.public.excel.programming
Don Guillett[_4_]
external usenet poster
Posts: 2,337
summing values according to name in defferent column
try these
=sumproduct((rngA="Name")*(rngB="A")) to count
=sumproduct((rngA="Name")*(rngB="A")*(rngC*rngD)) to sum
--
Don Guillett
SalesAid Software
Granite Shoals, TX
"Lorenzo" wrote in message
om...
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
Reply With Quote
Don Guillett[_4_]
View Public Profile
Find all posts by Don Guillett[_4_]