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

can ı make pivot using functions
 

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

can ı make pivot using functions
 

This is something different some reason couldn't post as a thread ---
Here is my question:
Can you protect only certain columns and cells and allow access of change to
other columns and cells without protecting the entire sheet. If you protect
the entire sheet how can you then just unprotect certain cells/columns?

Thanks
Clarence

"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

can ı make pivot using functions
 

Rght click on the cells/columns you don't want protected.

go to Format Cells

go to the Protection tab

uncheck the locked checkbox.

"Clarence" wrote:

This is something different some reason couldn't post as a thread ---
Here is my question:
Can you protect only certain columns and cells and allow access of change to
other columns and cells without protecting the entire sheet. If you protect
the entire sheet how can you then just unprotect certain cells/columns?

Thanks
Clarence

"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