Dynamic formula to calculate percentage

[Belair58]

Hello,

I currently have a formula at the end of column P that shows the percentage of a particular entry in the column.

=ROUND((COUNTIF(O2:O535,"Late")/COUNTA(O2:O535)*100),2) & " % Late"

I've been asked to add subtotals to this sheet, AND to have this formula at each subtotal line.

I'm currently working on looking for a blank cell in column D and pasting the formula into column P. I think I'm close on that.

Here's the problem: My current formula needs to only look at the range of the subtotaled lines. Can anyone give me an idea of how I would make the formula be dynamic for COUNTIF(O?:O?,"Late")

There will be a blank cell in Column O at each subtotal if that helps to find the range.

Any help would be greatly appreciated.

 

[SpillerBD]

I've been asked to add subtotals to this sheet, AND to have this formula at each subtotal line.

The best way is a Pivot Table and provide the desired calculations at each desired Subtotal group. All the dynamics and formulas are taken care of by the Pivot Table. You only have to refresh the Pivot Table when data changes.