Only adding up what is visible and filtered.

I recently got asked this in class..one of the students had received a file from one of their customers (who had hidden some of the rows) and he wanted to only get the total for the visible, filtered rows. I tried a couple of things – including Visible Cells...