Challenge #1: Join to Range

[SevenConsulting]

Spoiler

[vamsisridhar]

Solved it using filter condition to label rows, and then summarized it. 

Not the most elegant, but gives the required output. 

Vamsi 

[urgatorb8]

Finished

[LelandM]

Finished.

[saintshane]

I think this is how you are supposed to do these challenges and get credit for it. Well here is my answer, anyway.

[saintshane]

Here is my solution.

[alyssa_sedai]

Well better late than never so see attached.

[ksheerasagarm]

Here is the solution for Challenge 1