I wanted to see if I could get advice on how I would go about applying a formula to subtotaled data (formula autoadjusts itself to look at the correct range of data in the subtotaled section):
Scenario:
Data is subtotaled by a customer name
Customer has different status of open and closed projects (data element indicates the status- OP for open CL for closed for each project).
I'd like to know the % of closed projects for each customer populated beside the subtotaled data. (I've come up with =(COUNTIF(E2:E20,"CL")/COUNTA(E2:20)) as an example- trying to figure out how to get excel to use this same type of formula for the additional subtotals (for customer) below this.
End result in would look like:
Customer A - 50% compelete
Customer B- 90% complete
....
This would need to be done daily based on new data- just trying to find a way to automate this.
I really apprecaite any advice /assistance/ guidance.
Thanks!!
Scenario:
Data is subtotaled by a customer name
Customer has different status of open and closed projects (data element indicates the status- OP for open CL for closed for each project).
I'd like to know the % of closed projects for each customer populated beside the subtotaled data. (I've come up with =(COUNTIF(E2:E20,"CL")/COUNTA(E2:20)) as an example- trying to figure out how to get excel to use this same type of formula for the additional subtotals (for customer) below this.
End result in would look like:
Customer A - 50% compelete
Customer B- 90% complete
....
This would need to be done daily based on new data- just trying to find a way to automate this.
I really apprecaite any advice /assistance/ guidance.
Thanks!!