Evil Kraig F (8/25/2011)
Excellent examples and a solid walkthrough, thank you.
Btw, for your question about real-use of range, you'd have to wrap the results in a distinct.
I'm thinking of log-entries. If you want by day-running totals, you'd do a by range and then distinct the results on the summed columns and the leading identifiers. This way if 2 ppl worked on a project 1 day and 10 people the next you could still have 2 rows, one identifying each day after the distinct with the correct totals.
Ah! Great example - thanks!