Subtotal ranges when copying formulas through the report

I have a report that I subtotaled on sum on 1 column

I have since had to add more columns with much more complicated formulas, but I need the range of cells that was part of the subtotal. The problem is that some ranges are 1 row and other ranges can be 200 rows - they vary.

Right now I am copying the range from the subtotal sum cell that was auto created with the subtotal function and entering it into my complicated formula, which gets tedious since I have to do this about 50 times.

There has to be a better, smarter way?

Tons of confidential information....but let me see if I can scrub it.....
Ok,
I subtotaled on the Client Name and Sumed the Pay Reg Hours column
Then I had to add the calculations and formulas into D, K, L, M, and N

I had to manually enter the range in the formula - for example for Big Bird I had to enter E2:E8 for the formula in Column D and again in the rest of the columns mentioned above for the formulas (rows 2-8 in various columns)

Then I had to do the same in thing for each of the clients on the subtotal line (d9, d23, d40, etc)
Is there a way to let it calculate those ranges without me doing it manually?

Does that make better sense?

hmmmm, my frequency formula in E isn't working either...because there are multiple days with different times and it is counting each instance instead of each day.

You are absolutely my heros!!!!! That was SO much faster and easier than what I was doing! While the pivot table wasn't what I was going after, it did get me to thinking about how I might be able to use pivot tables in the future (I have started down a very detailed data analysis road these days).

FlameRetired - the last array formula was absolutely what I needed - and now I'm thinking about how else it might be able to help me, so thank you!