An interesting challenge as it too me a bit to realize that this one was two parts:
My solution is attached. I really thought I could do the bulk of the work with multi-formula tool, but I just couldn't make it work any better than the standard tool. I feel multi-formula is really powerful, but I can't quite get a grasp it. So I just used a combination of the standard formula tools and the summarize tool to make it work.