Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create and Link check box with autofilter and sum, average of filtered raws.
I maintain the huge database in excel for our products and sales. It
is used by many users over the network. I want to have set up a row in the top of sheet where I will put 4 check boxes (for 4 items) and link them with another two cells which will show the sum for that item and average for the same item. Also when the any box is checked, entire range of data should got autofiltered for that item. If multiple boxes are checked, filter, sum and average should be applicable to all the checked items. I am new in excel and programming. I dont know how to create check boxes and link it with the formula of sum, average and autofilter. Any pointing in that direction will be helpfull. Regards, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting Filtered Results Using Autofilter | Excel Worksheet Functions | |||
Copy and move check box (check boxes) with new cell link? | Excel Worksheet Functions | |||
Autofilter and count on filtered data | Excel Worksheet Functions | |||
How do i view only the filtered results from autofilter ? | Excel Discussion (Misc queries) | |||
Way to display filtered results from more than one autofilter per | Excel Worksheet Functions |