Calculate percentage of cells complying to one criteria

Margherita Falavigna

Hi,

I need to calculate the percentage of cells within a certain time frame that comply to a certain criteria.

More specifically, I need to calculate the % of complaints closed in the past 28 days (Date of closure = TODAY -28) that have a complaint investigation duration of less than 15 days.

Please find an example of the sheet I need to use for the calculation.

Help would be highly appreciated.

Margherita

Sing C

Hi @Margherita Falavigna,

I hope you are well. You could capture the % in a Sheet Summary Field, using the following formula:

=COUNTIF([Date of Closure]:[Date of Closure], >TODAY(-28)) / COUNT([Date of Closure]:[Date of Closure])

Remember to set the formatting of the Sheet Summary Field to 'Percentage'.

Let me know if this will work for you.

I hope this helps.

Have a wonderful day!

Thanks,

Sing

Sing C

Hi @Margherita Falavigna,

I hope you are well. You could capture the % in a Sheet Summary Field, using the following formula:

=COUNTIF([Date of Closure]:[Date of Closure], >TODAY(-28)) / COUNT([Date of Closure]:[Date of Closure])

Remember to set the formatting of the Sheet Summary Field to 'Percentage'.

Let me know if this will work for you.

I hope this helps.

Have a wonderful day!

Thanks,

Sing

Margherita Falavigna

Super! It works! Thanks a lot for the feedback :)