Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to ignore the signs and make the functions work | Excel Worksheet Functions | |||
How do I make my functions public to all workbooks? | Excel Discussion (Misc queries) | |||
Can I make if functions based on fill color? | Excel Discussion (Misc queries) | |||
Please make it easier to access the IS functions (e.g., isblank) . | Excel Worksheet Functions | |||
Define inputs and outputs to make functions from sheets | Excel Discussion (Misc queries) |