Chandoo: You are right, it is not a true 'sum'. It's more of a collected list than an actual sum. Poor wording on my part :D My apologies for the confusion. I edited my original post in hopes of adding clarity and reducing confusion.
Chandoo & Luke: I'll give your suggestions a try and report...
Hi Chandooans :)
I'm trying to come up with an efficient way to do the following:
1. Test a cell (we'll call it A3) for a specific time in text (i.e. 15:00)
2. Collect contents of a cell (call it H17) and below with A# cells that match the 15:00 time text
3. Output a median of that list...