Only adding up what is visible and filtered.

Published: Fri, 05/22/15

The Excel Expert

Learn to love Excel - one cell at a time. Tutorials for beginners, tips for experienced users

Only adding up what is visible and filtered.- 2015-05-18 07:38:02-04

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 only (F5 – Special – Visible […]
Read more...

Filter one list depending on contents of another plus intro to hurling- 2015-05-19 04:50:34-04

I recently met with a friend of a customer and after I let him into the secret of pivot tables, he asked me about helping him create two dropdown lists. The idea being that the contents of the second one would depend on what was chosen in the first one. In the example below, I’ve […]
Read more...