xiaoyunwu
asked on
excel unique value sum
I have sheet 1
product_id, user_id, price
1, u1, 10
2, u2, 20
3, u1, 20
4, u2, 30
I'd like to have unique user_id and sum of price in another sheet automatically filled in. like:
user_id, price
u1, 30
u2, 50
How do I do that? Thanks.
product_id, user_id, price
1, u1, 10
2, u2, 20
3, u1, 20
4, u2, 30
I'd like to have unique user_id and sum of price in another sheet automatically filled in. like:
user_id, price
u1, 30
u2, 50
How do I do that? Thanks.
http://www.get-digital-help.com/2009/04/20/sum-unique-values-in-excel/
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.