Help with Average Formulas

aneves

Hi! I am trying to calculate a 3 months, 6 months and 1 year averages of my team utilization percentage. Each team member is a row and then each month is a column. The utilization percentages are coming from other sheets.

Thank you in advance!

SSFeatures

Hi,

Would something like this work:

=AVG([08.2024]@row:[June-24]@row)

This will give the average of the columns 08.2024, 07.2024, and June-24 in your sheet. You can follow this format to calculate the 6 month and 12 month averages as well.

If you right click a cell in your 3 month average column, then click Convert to Column Formula you can apply the formula to the entire column as well.

The only downside to this approach is that you will need to update the formula every month when you add new data.

SSFeatures

SSFeatures

Hi,

Would something like this work:

=AVG([08.2024]@row:[June-24]@row)

This will give the average of the columns 08.2024, 07.2024, and June-24 in your sheet. You can follow this format to calculate the 6 month and 12 month averages as well.

If you right click a cell in your 3 month average column, then click Convert to Column Formula you can apply the formula to the entire column as well.

The only downside to this approach is that you will need to update the formula every month when you add new data.

SSFeatures

aneves

OMG! it worked! thank you so much!!