Chaning the Total Value of Filtered Projects

  • Thread starter Thread starter Funkydan
  • Start date Start date
F

Funkydan

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?
 
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
 
Back
Top