Apply formula to filtered data (2003)

Is there a way to create a formula which will modify it's results as the basis of filtering the data. When I filter the data, the formula results still use the entire data set, not the data that appears on the screen (results of the filter).