Filtering a table with formulas

Hello,  I would like to know how I could possibly filter my table but have the table update the formulas that are in it so as not to include the filtered out section of the table.  Short example: ...