| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Chaning the Total Value of Filtered Projects
Hello all i was wondering if you could help me,
i have say two columns which column A is A3:A10 which have projects Names and then Column B3:10 have Tender Values. In Column A2 I Have the Field Name Projects Which has an Auto Filter Which allows me to Filter So Just the New Look Projects and Lists there Values. I Would like is a Totals Cell Which Changes the tender values depending on what projects is selected. How Do i do this? i tried to use the Subtotals Formula but couldnt quite get it to work? or am i better off using a different formula? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro chaning | New Users to Excel | |||
| total on filtered data? | Excel Worksheet Functions | |||
| HOW DO I TOTAL A FILTERED LIST TO EXCLUDE THOSE EXCLUDED BY FILTE. | Excel Worksheet Functions | |||
| How can I show the total sum of items in a filtered column | Excel Worksheet Functions | |||
| How to have total for filtered data?? | Excel Discussion (Misc queries) | |||
Threaded Mode
