AVERAGEIFS help

[mang121]

I cannot figure out why this formula comes up witht he #DIV/0! error. I 'm sure its something simple I am overlooking. Any help would be appreciated. Thanks.

 

[Norie]

The formula works fine for me, are you sure the values in column A are numeric?

 

[mang121]

The formula works fine for me, are you sure the values in column A are numeric?

Thats what it is. Since this data is pulled from another worksheet, how do I format the column to numerical values?

 

[awoohaw]

@mang121

It looks like your column A is text as it is "LEFT ALIGNED" in the picture.
What you can do is highlight column A and change the format to "GENERAL" and make sure your column is normal alignment.
If it is aligned left then it is not a number.

Or, try to format the column as a NUMBER with a bunch of decimals. If it does format it is not a number.

 

[mang121]

I got it now. I had to reformat the

@mang121

It looks like your column A is text as it is "LEFT ALIGNED" in the picture.
What you can do is highlight column A and change the format to "GENERAL" and make sure your column is normal alignment.
If it is aligned left then it is not a number.

Or, try to format the column as a NUMBER with a bunch of decimals. If it does format it is not a number.

Thank you. I figured it out. I changed the format to number on the data sheet and it works now. Thanks for the help!