check out the SUMIF function in the XL help file.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"tuncay" wrote:

Hello Everybody
ı want to sum 2 or more same character as pivot
ı dont want to make pivot function because always ı should make 2 pivot and
click refresh button on pivot
ı want to make it automatically
problem like this
A B C
01-01 DBC 120
02-01 GFC 250
01-01 SAC 300
02-03 GFC 400
I want to sum acorrding to "GFC" and in other column ı want to sum according
to "01-01"
when ı change some data in this range sum should change automatically