# shows up for average

Copper Contributor

I am using the averageif formula for multiple rows.  for some of the rows it works fine, but for others it returns just a #.  if i change it to just the average formula the same thing happens.  any ideas?

2 Replies
usually that's a sign that the number is too wide to fit in the cell....and it's resolved by widening the column

i thought that at first but it is not the case.@mathetes