First...thank you for the prompt reply!

But I am receiving an error:

cannot perform an aggregate function on an expression containing an aggregate or a subquery

I'm thinking I need to break this out into two subqueries?