View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tuncay tuncay is offline
external usenet poster
 
Posts: 2
Default can ı make pivot using functions

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