Dynamic calculations for cost when filtering

Hi Guys,

I have a spreadsheet that I use for adding up various invoices.

What I wanted to know is when I use the auto filter command for the various invoice numbers.

What I wanted to know is, when I autofilter my sheet to a particular invoice number can I get the total cost in the 'Cost' field to dynamically change to reflect only the amount for a particular invoice without using a Pivot Table?

Could I use the OFFSET command?

I have over a dozen sheets identical for various cost centres so it would be nice if this could be done.

Thanks in advance.

Does link help

http://www.contextures.com/xlFunctions01.html#Filter

VBA Noob

Thanks VBA Noob, I shall check out the link.

@VBA Noob

Thank you so much for that link, the SUBTOTAL function is absolutely amazing and is exactly what I needed, I can't believe I have not come across this function in all my time using Excel.

It worked great so thanks again for your help

Glad it helped

VBA Noob