Filtered Results

[doug.washburn]

Hi again,

I have a spreadsheet that tracks the quality control scores of various vendors all on the one sheet. At the top, I have a cell that calcultes the percentage pass of all the entries on that sheet. If I have 5 different vendors all on one sheet, it gives me the average pass for all 5 combined. I'd like it that when I use the auto filter to show only one vendor, the average at the top would only claculte for the filtered vendor (right now it still shows the average for all).

Is this do-able?

 

[Gerald Higgins]

Yes it's do-able, using the SUBTOTAL function.