Formula for avg of 1 column to a specific issue in another column

DannyApa

Sheet summary looking to get an average time to repair for specific issues that come in. Currently I have a formula that show AVG for every issue

Trying to get a formula to show this average to add to a dashboard view

Genevieve P.

Hi @DannyApa

You can use an AVERAGEIF Function to Average one column based on criteria in another.

Example structure:

=AVERAGEIF([Criteria Column]:[Criteria Column], "Criteria", [Column to Avg]:[Column to Avg])

In your sheet, it would look something like this:

=AVERAGEIF([Issue Category]:[Issue Category], HAS(@cell, "Connectivity"), MTTR:MTTR)

I used the HAS Function because it looks like your Issue Category column is multi-select. HAS will find any cell that has that specific selection, even if it's with other values. Let me know if this works for you!

Cheers,

Genevieve

Genevieve P.

Hi @DannyApa

You can use an AVERAGEIF Function to Average one column based on criteria in another.

Example structure:

=AVERAGEIF([Criteria Column]:[Criteria Column], "Criteria", [Column to Avg]:[Column to Avg])

In your sheet, it would look something like this:

=AVERAGEIF([Issue Category]:[Issue Category], HAS(@cell, "Connectivity"), MTTR:MTTR)

I used the HAS Function because it looks like your Issue Category column is multi-select. HAS will find any cell that has that specific selection, even if it's with other values. Let me know if this works for you!

Cheers,

Genevieve

DannyApa

Thank you so much. The formula worked like a charm

Genevieve P.

Wonderful! I'm glad I could help. 🙂