add values in a filtered list

Hello!

I keep track of all purchases on a spreadsheet. One column has the price of the purchase and another column has the work order#. When I filter the data to display the records of a specific work order I would like a total of how much was purchased for that work order.

Is it possible to add the price column of the filtered data?

Thanks in advance.
Kerri

If both columns are in the filter, it should automatically do what you're wanting, if I'm reading your question correctly.