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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Chaning the Total Value of Filtered Projects
Hi,
This works for me =SUBTOTAL(109,B3:B10) Mike "Funkydan" wrote: 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Chaning the Total Value of Filtered Projects
On 28 Jan, 10:25, Mike H wrote:
Hi, This works for me =SUBTOTAL(109,B3:B10) Mike "Funkydan" wrote: 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? Thanks Mike, but i cant quit work out what the 109 or the formula is refering to? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Chaning the Total Value of Filtered Projects
Have a look in Excel Help for the SUBTOTAL worksheet function.
Basically, this will act only upon the visible cells. The parameter 109 means SUM cells in the range which are visible (i.e. those not hidden by autofilter or manually). If you have XL2k or earlier, then you will have to use 9 as the parameter - this does not account for cells (rows) which are hidden manually. Hope this helps. Pete On Jan 28, 12:01*pm, Funkydan wrote: On 28 Jan, 10:25, Mike H wrote: Hi, This works for me =SUBTOTAL(109,B3:B10) Mike "Funkydan" wrote: 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? Thanks Mike, but i cant quit work out what the 109 or the formula is refering to?- Hide quoted text - - Show quoted text - |
Reply |
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) |