Average Formula

Maria Watters

If I am wanting to find the average of wage rates that are referenced on another sheet, how would I create that formula? I have tried several different things and nothing appears to be working.

Genevieve P.

Hi @Maria Watters

Would you be able to explain further? You say that nothing is working, does that mean you're receiving an error?

You will want to use Cross Sheet references (see here) in your formula in order to Average the column. It would look something like this:

=AVG({Column to Average})

Are you simply wanting to AVG the entire column or do you have criteria (ex. only average if a cell in a different column says something specific)? If you have other criteria, you would use an AVERAGEIF, like this:

=AVERAGEIF({Column with Criteria}, "Criteria", {Column to Average})

Keep in mind that the wage rates in the other sheet will need to be numerical data in order to be averaged. If neither of these formulas work for you, it would be helpful to see a screen capture of the sheet with the wage ranges (but please block out any sensitive data!) as well as a copy/paste of the formula you are trying and any error messages you're receiving.

Cheers!

Genevieve

Genevieve P.

Hi @Maria Watters

Would you be able to explain further? You say that nothing is working, does that mean you're receiving an error?

You will want to use Cross Sheet references (see here) in your formula in order to Average the column. It would look something like this:

=AVG({Column to Average})

Are you simply wanting to AVG the entire column or do you have criteria (ex. only average if a cell in a different column says something specific)? If you have other criteria, you would use an AVERAGEIF, like this:

=AVERAGEIF({Column with Criteria}, "Criteria", {Column to Average})

Keep in mind that the wage rates in the other sheet will need to be numerical data in order to be averaged. If neither of these formulas work for you, it would be helpful to see a screen capture of the sheet with the wage ranges (but please block out any sensitive data!) as well as a copy/paste of the formula you are trying and any error messages you're receiving.

Cheers!

Genevieve

Maria Watters

Thank you so much! I was using the wrong one, I needed the =AverageIF formula and it worked.

THANK YOU and sorry for the limited information I provided. Your response was very helpful!

Genevieve P.

Haha, no worries at all! I'm glad you were able to get it working based on my example above. 🙂