rajesh nag
08-25-2008, 11:00 PM
Hi,
I would like to select a unique value from one column and sum their values in another column. and build a chart
for example
Country Product Sales
USA Rice 544
UK Sugar 236
Canada Wheet 534
Srilanka Rice 673
UAE Wheet 432
i Should get
Rice 1217
Sugar 236
Wheet 966
I am able to get the sum of values using
=SUMIF(B$1:B$500,"="&B1,c$1:c$500)
and removing duplicates with ASAP
since their will be regular additions and deletions of rows in the columns
Can any one help me to select unique value from prduct column. Without using peot table and macros.
Regards,
Rajesh.
I would like to select a unique value from one column and sum their values in another column. and build a chart
for example
Country Product Sales
USA Rice 544
UK Sugar 236
Canada Wheet 534
Srilanka Rice 673
UAE Wheet 432
i Should get
Rice 1217
Sugar 236
Wheet 966
I am able to get the sum of values using
=SUMIF(B$1:B$500,"="&B1,c$1:c$500)
and removing duplicates with ASAP
since their will be regular additions and deletions of rows in the columns
Can any one help me to select unique value from prduct column. Without using peot table and macros.
Regards,
Rajesh.