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?